current position on the current line

[big_k105]

ok my question is that i have a textbox on a worksheet in excel and i want to be able to find out what the current position on the current line that im on. here is what im trying to do. ok i am first off converting a file from a emacs file to beable to be read and looked at in windows. and the tab stops to look right in windows. in emacs it make the tabs 8 spaces long and for some reason they are only like 5-6 or so in the textbox. and i want to beable to take a chr(9) which is tab and replace it with space(8) but here is where the problem is.

when you are in the first space on a line it and hit tab in emacs it moves over 8. then of you are on the 2nd it moves over 7 and goes to the same spot as the last tab this happens all the way over to space 8 where it starts over. and i need to be able to detect want spot the chr(9) was found on so i know how many spaces to go over. well hopefully someone can help. i currently dont have any code writen really. all i have is the code the replaces all chr(9) with space(8) if you want i can post that so you can look at how i do stuff.

well thanks for your help and hope you read this soon thanks :)

[big_k105]

'***********************************************'
' code that replaces the chr(9)'s with space(8) '
'***********************************************'
Dim curpos1 As Integer
thispos1 = 0
thispos1 = 0
startpos1 = 1
startpos2 = 1
'chr(9) replacing with 8 spaces
Do While True
thispos1 = InStr(startpos1, strFileRecord, Chr(9))
If thispos1 = 0 Then Exit Do
strFileRecord = Left(strFileRecord, thispos1 - 1) & space(8) & Mid(strFileRecord, thispos1 + 8)
startpos1 = thispos1 + 1
Loop
'***********************************************'
' code that replaces the chr(9)'s with space(8) '
'***********************************************'

[big_k105]

*bump*