george hart
Board Regular
- Joined
- Dec 4, 2008
- Messages
- 241
Hi all
I have a load of data on a spreadsheet that i'm unable to format as the initial source when copying has converted it into text.
Although I can run the below for column L which converts it back allowing me to format how can I get this code to convert the whole worksheet?
Range("L15:L33").Select
Selection.TextToColumns Destination:=Range("L15"), DataType:=xlFixedWidth, _
FieldInfo:=Array(0, 1)
Many thanks in advance
I have a load of data on a spreadsheet that i'm unable to format as the initial source when copying has converted it into text.
Although I can run the below for column L which converts it back allowing me to format how can I get this code to convert the whole worksheet?
Range("L15:L33").Select
Selection.TextToColumns Destination:=Range("L15"), DataType:=xlFixedWidth, _
FieldInfo:=Array(0, 1)
Many thanks in advance
