Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 783
Default Selecting a Cell inside a range

Vasant Nanavati wrote:

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

Or simply
Range("Prices")(1, 3).Activate

Alan Beban
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting the first cell of the last row in a range Susan Ramlet New Users to Excel 5 April 3rd 09 04:35 PM
Selecting range in list of range names depending on a cell informa Courreges Excel Discussion (Misc queries) 2 June 19th 06 10:59 AM
Selecting a cell in a range Coolboy55 Excel Worksheet Functions 0 August 31st 05 07:17 PM
Selecting a Range inside a range hcova Excel Programming 0 July 13th 04 03:26 PM
Selecting a cell range peterG Excel Programming 2 January 14th 04 05:55 AM


All times are GMT +1. The time now is 04:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"