Cell selection

[grahammal]

If I want to select a range of cells using

Please Login or Register  to view this content.

it works OK.
How do I achieve the same result using

Please Login or Register  to view this content.

the 3 & 22 being the range of rows and the 1 being column A.
I cant get it to work at all.
Have also tried

Please Login or Register  to view this content.

but no joy.
Thanx in advance
Pete

[redstang423]

Is there a specific reason you need to use the cells function? Do you just need to be able to refer to cells as numbers? I'm not sure of a way to select a range using just one cell function, but this has the same effect as what you are looking for without using "A1" or anything like that:

Please Login or Register  to view this content.

Jeff

[grahammal]

Thanx
Exactly what I was looking for.

[starguy]

Thanx
Exactly what I was looking for.

Hi Pete

Please read the forum rules. You must post your questions in relevant forums. Your thread is saved from being deleted or locked (good luck) and as you got the solution I am not deleting it however you are supposed to follow the rules in future.