I thinbk the code below is what you want. You don't havbe Z1 and Z2 defined.
I thionk you are referencing the workbook cells Z1 and Z2, therfore, you
need to use range.

sub SelectRange()

range("A1",cells((Range("Z1")+1),(Range("Z2")+1))) .select
end sub


"Neil Pearce" wrote:

Thanks Joel.

So if I wanted a simple macro code to attach to a button to select a range,
as dictated by cells Z1 & Z2, the following should work?

sub SelectRange()

range("A1",cells((Z1+1),(Z2+1))).select
end sub


Kind regards,

Neil

"Joel" wrote:

Using macros you cna reference cells either using numbers or letters. Cells
can ber referenced using eithe rRANGE or CELLS. Here are some examples

Range("A1:B10")
Cells(1,"B") row then column
Cells(1,2)
Range(cells(1,"A"),cells(10,"C")

for you case use the following
Range("A1",cells(X + 1, Y + 1))


"Neil Pearce" wrote:

Dear all,

Is it possible to reference cells in Excel using numbers for both rows and
columns rather than the letter and number reference as is standard?

If so, is it possible to write a macro that selects range A1 to A+X:1+Y
where X & Y are variable integers in other cells?


Thanking-you in advance,

Neil