| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is is possible to have a macro select a cell and return the address for use as a variable? | Excel Programming | |||
| select range and put range address in variable | Excel Programming | |||
| How can I use a variable as cell address? | Excel Programming | |||
| Select Cell based on Variable address | Excel Programming | |||
| Setting a variable cell address | Excel Discussion (Misc queries) | |||
Hybrid Mode
