Hi Bill,
No problem, thanks for the feedback.

re macros at a novice level:
As TaylorJ has mentioned the best way is to play around by recording
chunks of macros & breaking down the code (use [F8] to step through
code a line at a time, with your VBE window 1/2 size so you can see
what is happening in Excel). Make use of the [F1] key when needed &
search the news groups (you'll learn heaps).
It's always easier to learn when you have a specific goal in mind, but
for general background info have a read of Dave McRitchie's intro:
http://www.mvps.org/dmcritchie/excel/getstarted.htm (good for
beginners)

Also, some other sources of info for optimising macros/worksheets may
come in handy as you get further into writing macros (it's wise to
learn good habits when you start though):
http://www.cpearson.com/excel/optimize.htm
http://www.ozgrid.com/VBA/SpeedingUpVBACode.htm
www.decisionmodels.com

Hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...

Psycho0426 Wrote:
Sweet! Thanks, both of you, for the help. Is there someplace online
that I can learn how to write macros from a novice level? I'm trying
to understand what I cut and pasted, but it's way over my head. Thanks
again. :)


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=526317