I have some code that uses offset to select a column of numbers
Range(HomeCell).Activate
ActiveCell.Offset(6 + Shift, 1).Range("A1:A15").Copy
However, I want to vary the range depending on a parameter passed to the routine.
i.e. Range("A1:A15") can vary - it may not always be A15.
Initially I naively tried
ActiveCell.Offset(6 + Shift, 1).Range("A1:A(Roze-6)").Copy
but of course that didn't work.
I tried various attempts at using Cells method, and R1C1 notation but no luck
The Cells method selects but it is always in reference to the start of the spreadsheet not the active cell.
Any suggestions?
Thanks
Bookmarks