Selecting Cells Dynamically in Different Rows
Thanks a LOT Excelent...
Half of my problem is solved. By Looking at your example I found out
the way to select required cell in my required row.
------------- Code -------------------------------
my_row = ActiveCell.Row
Range("F" & my_row).Select
------------------------------------------------------
Works fine !!
Now for the other half...
Kindly tell me what should i do if I know the COLUMN and want to go to
a required Row ???
I have tried the following code but it does not work.
---------------------- Code ----------------------
my_col = ActiveCell.Column
Range( my_col & 19).Select
------------------------------------------------------
Perhaps this is because in this case the value stored in My_Col is not
the 'name' of the column ( like A , B or C) but the 'Number' of the
column ( i.e. 1, 2 or 3 instead of A , B or C).
Kindly guide me what to do ??
Thanks a lot for ure valuable help !
|