I am trying to select a new cell whose row address is based on a variable
 

I getting an error on the following line:

Range(Cells(intRow1 - 1, "aa")).Select

I want to select a cell located at row intRow1 and column "AA"

any help would be appreciated.

I am trying to select a new cell whose row address is based on avariable
 

cells(introw1,"AA").select

Did you mean introw1-1 or introw1?



rub wrote:

I getting an error on the following line:

Range(Cells(intRow1 - 1, "aa")).Select

I want to select a cell located at row intRow1 and column "AA"

any help would be appreciated.

--

Dave Peterson

I am trying to select a new cell whose row address is based on a variable
 

Thanks Dave

I did mean intRow1-1


Dave Peterson wrote:
cells(introw1,"AA").select

Did you mean introw1-1 or introw1?



rub wrote:

I getting an error on the following line:

Range(Cells(intRow1 - 1, "aa")).Select

I want to select a cell located at row intRow1 and column "AA"

any help would be appreciated.

--

Dave Peterson

I am trying to select a new cell whose row address is based ona variable
 

try this:

Cells(intRow1 - 1, "aa").Select


rub wrote:
I getting an error on the following line:

Range(Cells(intRow1 - 1, "aa")).Select

I want to select a cell located at row intRow1 and column "AA"

any help would be appreciated.

I am trying to select a new cell whose row address is based on a variable
 

thanks John


John Smith wrote:
try this:

Cells(intRow1 - 1, "aa").Select


rub wrote:
I getting an error on the following line:

Range(Cells(intRow1 - 1, "aa")).Select

I want to select a cell located at row intRow1 and column "AA"

any help would be appreciated.