use vba to select a range of cells

[dgraham62]

Hi,

I'm having trouble attempting to use VBA to select cells.

I have 7 cells selected in row 4, what I need to do is keep those cells selected and also select down a number of rows (the number can change) to copy the cells in row 4. Any assistance is appreciated.

Regards
David

 

[alansidman]

crosspost

https://www.excelforum.com/excel-pr...and-copy-down-to-variable-number-of-rows.html

 

[Macropod]

dgraham62: Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html