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!)


--
jaimetimbrell
------------------------------------------------------------------------
jaimetimbrell's Profile: http://www.excelforum.com/member.php...o&userid=26162
View this thread: http://www.excelforum.com/showthread...hreadid=508365