Hi Art,

Add a new worksheet and then copy
the required range to the new sheet.

If you need to automate this, turn on the
macro recorder and perform the necessary
operations manually. This will provide you
with code which may be edited to afford
more generic application.

If you experience problems in editing the
recorder code, post back with the
problematic code.



---
Regards.
Norman


"Art" wrote in message
...
I need to save a range in a worksheet as a new worksheet. How can I define
a
Saveas to only save the particular range?