Changing range selected with variable

I have some code that uses offset to select a column of numbers

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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

You included Roze-6 inside the " marks which meant Excel treadted it as a text string not a variable & you did not use anthing to join you commands
To join you need to use & or +
Personally I prefer to use & leaving the + for formulas

Please Login or Register  to view this content.

Another way of doing it is

Please Login or Register  to view this content.