Hi
try
sub foo()
dim rng as range
set rng = selection
'your code
rng.select
end sub

--
Regards
Frank Kabel
Frankfurt, Germany


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
item being processed.

But now when the macro is finished executing, the row following the
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...


Mekratrig


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