Visions_Fugitive
New Member
- Joined
- Apr 15, 2002
- Messages
- 18
I have a macro that needs to loop through all the selected columns, performing an operation on each of them. I just need a way to get the numbers of the first and last columns.
firstCol = Selection.??????
lastCol = Selection.??????
For x = firstCol To lastCol
Columns(x).TextToColumns DataType:=xlDelimited, _
ConsecutiveDelimiter:=False, Space:=False
Next x
Thanks in advance.
This message was edited by Visions_Fugitive on 2002-04-16 14:39
This message was edited by Visions_Fugitive on 2002-04-16 14:39
firstCol = Selection.??????
lastCol = Selection.??????
For x = firstCol To lastCol
Columns(x).TextToColumns DataType:=xlDelimited, _
ConsecutiveDelimiter:=False, Space:=False
Next x
Thanks in advance.
This message was edited by Visions_Fugitive on 2002-04-16 14:39
This message was edited by Visions_Fugitive on 2002-04-16 14:39