How do you pass a column range as an argument to a subroutine?

Perhaps my question is too simple as I cannot find an appropriate answer in the forums or online references.

I need to interactively format many iterated worksheets that are generated with an external program. Once done, I need to add new columns and format those columns. There is much repetition in the columns (comparisons against an index sheet) and repeating all that formatting code is unwieldy and I suspect slowing down performance. So to get to it:

Please Login or Register  to view this content.

This pseudocode example would give me an error (type mismatch) every time. Futzing with quotes did no good.

Any help on the correct syntax would be very much appreciated.

Thank you in advance.

Try:

Please Login or Register  to view this content.

Something like

Please Login or Register  to view this content.

EDIT: Sorry xl, you beat me to it.