Try :
ActiveCell.EntireRow.Cells(4, tempCol).Select

"Terence C" wrote:

Dear all,

I am writing a program which can select a cell with dynamic column value.

e.g. if the row is fixed to 4th row and the colum can be any value, I used
the following code:

ActiveSheet.Cells(4 & "," & tempCol).Select

If the value of tempCol is 3, it is supposed to select the cell at the 4th
row and 3rd column, but it ends up with selecting the cell at 1st row and
43th column

So anyone knows how to handle this? Thanks in advance.

Terence