| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a Cell inside a range
Then use this
Dim col As Integer col = 3 Range("Prices").Cells(4, col).Activate -- Regards Ron de Bruin http://www.rondebruin.nl "Khlaudhya" wrote in message ... And the column is a variable "product" "Khlaudhya" wrote: 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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting a Cell inside a range
Hi,
this was very simple and I'm about to kick my self for not getting there... thank you. "Ron de Bruin" wrote: Then use this Dim col As Integer col = 3 Range("Prices").Cells(4, col).Activate -- Regards Ron de Bruin http://www.rondebruin.nl "Khlaudhya" wrote in message ... And the column is a variable "product" "Khlaudhya" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
| Selecting a cell in a range | Excel Worksheet Functions | |||
| Selecting a Cell inside a range | Excel Programming | |||
| Selecting a Cell inside a range | Excel Programming | |||
| Selecting a Range inside a range | Excel Programming | |||
Linear Mode
