You have hit upon the major limitation of recording macros, you have to
do exactly the same thing each time. By manually editing the macro you
have recorded or by writing one from first principles, you can overcome
this limitation. There are some examples on my download page which show
what a non-recorded macro might look like.

In you particular case, I would suggest that you look at the macro code
(ALT F11) and you add a new line to the beginning just after the Sub
Macro1 line.

Range("A1").Select

This will work assuming that A1 is the cell that has to be selected in
order for the macro to work properly.

The effect of this line is to mimic the action of selecting the cell.

I hope that this helps.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=539504