Copying variable columns from one worksheet to another

B

Biltong

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
 
Top