kelleygirl,

You can do it either way.
If you put it into an existing macro, get rid of the Sub xxxx() and End Sub
Or you can call it from a sub by putting in a line

*code here*
Call xxxx
*more code here*

or Run xxxx
(I'm never sure which is correct)

I usually use
ModuleName.MacroName
to be more specific.
I also usually rename my modules with the property window. But never,
never, never, ..... name a module and a macro the same.

--
sb
"kelleygirl" wrote in message
...
Thak you very much.

One question, though.

Can this be added to the existing macro or does it have to be a
separate one?

Adding "sub" seems to separate them.



------------------------------------------------
Message posted from http://www.ExcelForum.com/

-- View and post Excel related usenet messages directly from
http://www.ExcelForum.com
-- Hundreds of free MS Excel tips, tricks and solutions at
http://www.ExcelTip.com/
------------------------------------------------