VBA Select all columns but one

[LNG2013]

In VBA how can I select all columns but one?
I need to select all of my columns except for Time_Stamp, and have all of the the select columns set to to text.

 

[Desu Nota from Columbus]

In VBA how can I select all columns but one?
I need to select all of my columns except for Time_Stamp, and have all of the the select columns set to to text.

Example:

Assume only Columns A-Z exist and we want to select all except X,

Range("A:W,Y:Z").Select

Is this what you are looking for?

What do you mean "set to to text"?

Set the format for the selected columns to TEXT?

Range("A:W,Y:Z").Select
Selection.NumberFormat = "@"

The above code formats Columns A-W, Y, Z to TEXT (skips column X)

 

[LNG2013]

Sorry my columns change order, meaning what is A one day might be C the next, so I was looking to select all omitting the Time_Stamp column.... by "set to text," I meant to format all of those columns to text.

Thanks for your help!

 

[VoG]

Maybe like this

Sub test()
Dim Except As Long, LC As Long, j
Except = Rows(1).Find(what:="Time_Stamp", LookIn:=xlValues, lookat:=xlWhole).Column
LC = Cells(1, Columns.Count).End(xlToLeft).Column
For j = 1 To LC
    If j <> Except Then Columns(j).NumberFormat = "@"
Next j
End Sub

 

[Desu Nota from Columbus]

Sorry my columns change order, meaning what is A one day might be C the next, so I was looking to select all omitting the Time_Stamp column.... by "set to text," I meant to format all of those columns to text.

Thanks for your help!

Are you saying that Cell 1 in each column contains a heading?

 

[Desu Nota from Columbus]

Maybe like this

Sub test()
Dim Except As Long, LC As Long, j
Except = Rows(1).Find(what:="Time_Stamp", LookIn:=xlValues, lookat:=xlWhole).Column
LC = Cells(1, Columns.Count).End(xlToLeft).Column
For j = 1 To LC
    If j <> Except Then Columns(j).NumberFormat = "@"
Next j
End Sub

Peter you are too quick!! I was stumbling my way through writing something much less concise.

This does the trick.

 

[LNG2013]

VoG!

Bam!

You Sir are fantastic!

That works, I worked this into my code after it imports the csv to keep my columns from getting auto formatted!