Macro to copy to formula down to last row with data in

[robertguy]

Hi,

Can anyone please advise me of the macro/VBA I need to copy a formula in cell ‘AL2’ down ‘Column AL’ i.e. to the last row with data in

Many thanks in advance for any assistance required

Regards

Rob

[Special-K]

Data in what column?

[robertguy]

Special-K,

the formula in cell 'AL2' is a Vlookup formula that I want the macro/VBA code to copy down column 'AL' i.e. to the last row with data in (Columns A:AM)

Regards

Rob

[Special-K]

Try (untested so save your data first)

Please Login or Register  to view this content.

copies the formula in AL2 from AL3 onwards for however many rows there are in column A

[TMS]

You don't need to loop. You can do it tis way:

Please Login or Register  to view this content.