How to locate a cell with dynamic column value
 

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

How to locate a cell with dynamic column value
 

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

How to locate a cell with dynamic column value
 

Try
tempCol = 3
ActiveSheet.Cells(4, tempCol).Select

If this post helps click Yes
---------------
Jacob Skaria


"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