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

Locate Value in a set Row, with Dynamic Column 3
Selecting a column , row or cell 2
Determining Max value in a dynamic range 3
Find a value in a sheet and replace it with another value if it matches 8
Help with macro to delete rows 10
Count occurances in a range. 5
Named cells in an array to a column and to a row 3
HOW TO SELECT SPECIFIC CELL 2

Top