Trixie, you will pick up tricks and tips along the way from visiting
forums like this. The macro recorder is a fantastic tool and gets you
off to a good start, although the recorder is very exacting and gives
tons of code you don't really need, try experimenting with things that
you have recorded cutting some items out that you feel may not be doing
whatever task you require.

Glad we could be of help!

Trixie;422591 Wrote:


Oh my goodness Simon! emb1

You cut a bazillion characters from the macro recording I used down to
just that...where's the darned smilie with the super-hero cape?

How many times did you roll your eyes, shake your head and pop a Tums
to get through the original code I had in the workbook from the macro
recording?

Newbies wko
Although, I was able to add a msgbox and end with the cursor in A2 at
the end of the code...all by myself!


Thanks again for helping me with this.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=116018