View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Frank Situmorang Frank Situmorang is offline
external usenet poster
 
Posts: 97
Default How to return the cursor back to original cell

It is not clear to me excellent, are y saying in the first row of the macro
we type:
org = ActiveCell.Address
and in the last row we type:
Range(org).Select

I appreciate if you could elaborate it again,

Thanks,

Frank

"excelent" wrote:

First in macro:
org = ActiveCell.Address
Last in Macro:
Range(org).Select



"Frank Situmorang" skrev:

Hello,

I have created a data bank using a kind of filter. At the top row I have a
button of macro for hiding and unhiding columns.

My question is what VBA should I put in order to put the cursor back
automatically jump back to original cell. To be more clear, following the
sample:

Macro button
a b c d e
1
2
3
4 original cursor here, after filtered

I want the cursor back to original when pressing button,

We appreciate for any idea.

Thanks in advance

Frank


2
2