Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
locate cell with specific text and select that column | Excel Discussion (Misc queries) | |||
Locate last cell in column | Excel Discussion (Misc queries) | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Excel Programming | |||
How to locate the Row and Column of an Active Cell | Excel Discussion (Misc queries) |