that is what was suggested - but I believe the poster was assuming you would
process the whole sheet.

If you want to designate the range to work on by selecting it, then you can
make your macro use references like

ActiveCell

Selection and so forth.

then you wouldn't have to change anything in the code.

Regards,
Tom Ogilvy


Joy Chen wrote in message
...
Do you mean going into the micro each time and manually change the
select cell, e.g. "A1", to the disired new location?



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!