Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 ! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selecting data from cells that are 5 rows apart and groung in 1 co | Excel Worksheet Functions | |||
after selecting 50 rows of a column i can't reference the cells in the rows | New Users to Excel | |||
Selecting rows from cells | Excel Discussion (Misc queries) | |||
selecting range of cells - variable # of rows | Excel Programming | |||
Dynamically locating value; selecting that row and everything above (or below) and deleting/copying | Excel Programming |