- Joined
- Aug 10, 2005
- Messages
- 17
- Reaction score
- 0
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!)
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!)