Dear All,

In my (recorded) macro there is this bit...

Range("Y5:AB5").Select
Selection.Copy
Range("Y6").Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
ActiveSheet.Paste

this copies the formulae down to the last active cell and pastes them...this is fine and is the only way I could think how to do it...but i only want to paste down as far as the number of rows in the adjacent "X" column next to the Range("Y5:AB5")...

The practical difference is pasting down only 200 or so rows as opposed to the 3000 rows and therefore a considerable time/file size saving...

...I have tried to look up various solutions but I am struggling...

Jaime
(LVP!)