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

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