Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to retain the a cell address so that after I
perform a few other routines I can go back to that cell (activate) and do other things. This is what I have and its not working. Dim st As String If IsEmpty(ActiveCell)=True |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Surely, you need to save the cell in a variable, such as
Dim oCell as Range Set oCell = Activecell ' do your stuff elsewhere oCell.Select -- HTH RP (remove nothere from the email address if mailing direct) "Dan" wrote in message ... I am trying to retain the a cell address so that after I perform a few other routines I can go back to that cell (activate) and do other things. This is what I have and its not working. Dim st As String If IsEmpty(ActiveCell)=True |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Return cell address of a cell based on contents of cell. | Excel Worksheet Functions | |||
Retaining cell reference in destination, when sorting source file | Excel Worksheet Functions | |||
Retaining date formatting in referencing cell | Excel Discussion (Misc queries) | |||
retaining cell data once entered | New Users to Excel | |||
retaining superscript after a cell merge using =text | Excel Programming |