I am writing a macro to copy a column (starting at B) and pasting it to
column B in another worksheet. After processing this column in the second
worksheet I go back to worksheet 1 and copy column C into Column B in
worksheet 2. This can continue for up to 120 columns. How do I set a range
that varies for copying in Worksheet 1?

Thanks

Vrystaat