select multiple columns macro

[JChandler22]

Hi -

I'm trying to find a way to select multiple columns via a macro, in reference to a named range called macroMark. That named range will shift left/right from time to time, and I'd like this macro to select the four columns immediately before the column that contains the cell called macroMark.

So, for instance, to select the ONE column immediately before, I'd write:

Please Login or Register  to view this content.

How would I select all FOUR columns before it instead of just one?

Many thanks.

[VBA Noob]

Any reason why you need to select the columns??

Maybe

Please Login or Register  to view this content.

VBA Noob

[JChandler22]

Thanks, that works great.

I'm actually not selecting them. That line is part of a larger block of code but I just isolated it and simplified it for the sake of easy explanation.

Thanks again.