Thread: I am trying to select a new cell whose row address is based on a variable
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default 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
Reply With QuoteReply With Quote