macro excel 2000

E

EK

running a simple macro to set print area, several print areas in same sheet for different info, want the macro to read what active cell the user is on when the macro is started so the last sting on the marco can return to the users active cell.
 
F

Frank Kabel

Hi
try something like
sub foo()
Dim rng as range
set rng = activecell
'... your code
rng.select
end sub
 
Top