VBA script for dragging down formulas

Hi Guys,

I need you expert help please. Having a few issues in writing some script that will automatically drag down formulas next to some evergrowing data files. So to explain:


I have a 'sheet' where i am importing some data from a another source.
The headers are on row 3
There are 24 columns of data that are being imported. from column 'A' to column 'X'
Each time i import this data the number of lines will grow.


So what i really need from you guys is some script that will enable me to:

Drag some formulas down in cells 'Y4 to BB4' to the last line in the sheet. Everytime i record a macro using 'relative references' it is still refering to the last line number rather the ever growing list of lines of data.


Any help here guys would be greatly appreciated!

Thanks in advance

Regards

Nick

Try this simplest technique to drag down formulas

Please Login or Register  to view this content.

Hi Mandeep,

Thanks for the response. Its not liking the second line of text though unfortunately:
Range("y4:BB" & lr).FillDown

Any ideas please?

Thanks

Nick

What is the formula you are trying to fill down?

Share your sheet with formulas you want to drag

'******************************
'Made by :- Mandeep baluja
'https://www.facebook.com/groups/825221420889809/
'https://www.linkedin.com/in/mandeep-baluja-b777bb88
Add Reputation if it helps

It's clear it's just a typo, it should be lrow on the second line too.

Ahh OPPZZZZ Sorry for typo

Absolutely Fantastic! Cheers Guys!

Your help is massively appreciated! Thanks