Macro to repeat autofil in several columns

[DKerr]

I have recorded and example macro for a spreadsheet. How would I edit this macro so that it will autofil/copy/paste text one column at a time (eg. first for column B then C then D then all the way to column CF). I need to do it one at a time as each column will have 50,000 rows of data.

Please Login or Register  to view this content.

[Domski]

Is the code applying a formula in row 2 as well?

There is usually a better approach than using autofill.

Dom

[DKerr]

Is the code applying a formula in row 2 as well?

There is usually a better approach than using autofill.

Dom

I want the formula in B2 to be copied down to B50000, then copy the formula C2 down to C50000 etc... to CF

[DKerr]

The copy/paste portion that relates to B3:B50000 is there to keep the formula in B2.

[Domski]

Try:

Please Login or Register  to view this content.

Dom

[DKerr]

Thanks a million, that works perfectly.