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

's Computer Specifications

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.

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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.
>

's Computer Specifications

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.
> >

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Select column in VB based on variable	James	Microsoft Excel Programming	2	9th Oct 2008 02:36 PM
select cell by variable name	Adam	Microsoft Excel Misc	6	20th May 2008 07:54 PM
select the range with the cell's position is a variable.	youu917@gmail.com	Microsoft Excel Programming	2	14th Mar 2008 02:46 AM
Is is possible to have a macro select a cell and return the address for use as a variable?	JasonK	Microsoft Excel Programming	1	21st Mar 2006 01:08 PM
Linking a cell to another workbook cell based on a variable name	=?Utf-8?B?QnJpYW4=?=	Microsoft Excel Misc	6	1st Jun 2005 11:54 PM