How to locate a cell with dynamic column value

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
 
J

Jacob Skaria

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

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Identical words 0
Drop down list control value in vba 2
Take active cell value in for loop and offset based on another cellvalue for columns to offset 0
Count occurances in a range. 5
Dynamic add formula 2
Skip copying empty column where remaining rows are filled 2
Advice on multiple macros, same code just a different column 9
linking cells in a column (result) to cells in a row (source) 1

Top