Loop using list of values

Hi,

I want to create a loop that performs only on certain specified columns.
Just wondering what the best way to do it would be.

I'm thinking maybe put the column letters into an array and use that.
I know this is way off, but hopefully you get the idea:

Please Login or Register  to view this content.

I am using Excel 2003.

Thanks

hi Treva26,

I don't know what the "best way" is, but here's an example of code I made earlier today to apply formatting to specific columns. - You can test it & let us know what the best approach is...

Please Login or Register  to view this content.

hth
Rob

Beauty!
I'm pleased I could help - thanks for marking the thread as solved

Rob