You are more likely to get a response to your thread on MrExcel click here
I have to go out now but I would suggest testing whether the last character in a line of text is a Tab (vbTab) and if it is then apply your test to the penultimate character.
WPA2 hack: How secure is your Wi-Fi?
Add Depth Of Field to a photo using Tilt Shift Blur in Photoshop
iPhone tips & tricks
Comment afficher des fichiers cachés sur Mac ?