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