Macro

  • Thread starter Thread starter hh
  • Start date Start date
H

hh

how do i record new macro so that when i run it, it
starts from the selected cell and not revert back to the
cells that i recorded it in?
thanks, desperate!
 
When you're recording the macro, you'll see two icons on that "stop recording"
toolbar.

The second one is "relative reference". Click it and see if that does what you
want.

Or maybe you could just examine the existing recorded code and start using
ActiveCell instead of the original's address.

You may want to post back if you have trouble. There might even be ways of not
selecting anything at all.

(Usually the code is easier to follow and runs a little quicker, too.)
 
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

Pasting cell contents into a macro 1
Code for multiple select of cells 16
Run Macro If Cell have "x" value 0
Combine 2 columns in a dynamic range into one 7
VBA set thick borders around non empty cells in range 0
Conditional Formatting macro: simple, but doesn't work 6
Insert cells 1
Remove Hyperlinks Without Changing background shading 14

Back
Top