How to locate a cell with dynamic column value

  • Thread starter Thread starter Terence C
  • Start date Start date
T

Terence C

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
 
Try
tempCol = 3
ActiveSheet.Cells(4, tempCol).Select

If this post helps click Yes
 
Back
Top