View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mekratrig Mekratrig is offline
external usenet poster
 
Posts: 1
Default Retain, restore selection?

I created an Excel VBA macro that processes a list of items in a column
As a visual aid, I modified the code to select the row of the ite
being processed.

But now when the macro is finished executing, the row following th
last column entry remains selected/hilighted.

How can I:
1) Save whatever cell(s) are selected upon entry to macro execution;
2) Restore the original selection when code is ready to exit?

Many thanks in advance...


Mekratri

--
Message posted from http://www.ExcelForum.com