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”