Hi jb,

Syntax is:-

Cells(Rownum,Colnum).Select

(Make sure you use Cells with an 's' on the end)

Regards,

OssieMac

"jb" wrote:

I'm trying to use variables and logic in some of Excel's methods & functions.
I'm not sure how to say this, so I'll use an example.

If I use the Macro record of Excel, and select a range or cell, or say goto
a cell or range I get something like this:

Range("O65").Select
Application.Goto Reference:="R18C5"

What I'd like to be able to do is to use these statements, with cell
addresses that I calculate baseed on my own variables.

Rownum = 5
Colnum = 10

Like in my imagined language, something like:
Range(rownum, colnum).select
Application.Goto Reference:="R"&rownum&"C"&colnum

Does anyone get what I'm saying and know how to do this.