View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default Selecting a Cell inside a range

Range("Prices").Cells(1, 3).Activate

--

Vasant

"Khlaudhya" wrote in message
...
Hi there,

I have a given range named "Prices" selected and I want to activate the

third column and first row of that range.

I have

Range("Prices").Select

Cells(1, 3).Activate

but this returns the cell "C1" activated.


Any ideas?

Thank you very much.

Regards,

Khlaudhya