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