is there a way to addreess a cell using the column number instead of the
column letter?

Instead of Range("A2").value .... Range(? & 2).value

Thank you

Hi Sandy

You can use Cells
Cells(row,column)

Sheets("Sheet1").Cells(1, 2).Value



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Sandy" wrote in message ...
is there a way to addreess a cell using the column number instead of the
column letter?

Instead of Range("A2").value .... Range(? & 2).value

Thank you

cells(?,2).value
Sandy wrote:
is there a way to addreess a cell using the column number instead of the
column letter?

Instead of Range("A2").value .... Range(? & 2).value

Thank you

To be consistent with your example, I think steve meant

cells(2,?) where, for column A, ? would be 1.

--
Regards,
Tom Ogilvy

"stevebriz" wrote:

cells(?,2).value
Sandy wrote:
is there a way to addreess a cell using the column number instead of the
column letter?

Instead of Range("A2").value .... Range(? & 2).value

Thank you