View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] alishehzad@gmail.com is offline
external usenet poster
 
Posts: 13
Default 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 !