Locating and selecting a column with VB Script

Gooday,

I’m trying to program a large macro and part of the macro involves locating columns by there header and moving them to a different worksheet. This needs to be done because the columns can be provided in different order.

How would I go about locating a column and then selecting it using VB.?

Example column name: “Vendor”

Hi
The answer depends on how you want to use the info obtained.
if row 1 has header, =match("Vendor",A1:R1,0) returns the column number where vendor is located.
Ravi

Originally Posted by ravishankar

Hi
The answer depends on how you want to use the info obtained.
if row 1 has header, =match("Vendor",A1:R1,0) returns the column number where vendor is located.
Ravi

That's not a VB script and that only indicates the position in the array; It does not select the column. I need to select the column so that I may move the entire column to an other worksheet