macro excel 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi
try something like
sub foo()
Dim rng as range
set rng = activecell
'... your code
rng.select
end sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide columns based on row values 2
Macro using relative references 5
Pasting cell contents into a macro 1
Active cell position for macro 8
Macro Help please 5
Run a macro in active cell only. Want to place current date/time. 1
How to Run a Macro from clicking a cell 11
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Back
Top