hi John,

It may be that some of the comments are not wrapping when being copy &
pasted into your code, or more probably, it could be that I'm using this
code in Excel 2007 & it may have some extra arguments that aren't
identified in older versions of excel.

Let us know which lines highlight when you step through the code with
the [F8] key (or try to compile it using [alt + D + L]) in the VBE.

Rob


--
broro183

Rob Brockett. Always learning & the best way to learn is to
experience...
------------------------------------------------------------------------
broro183's Profile: http://www.thecodecage.com/forumz/member.php?userid=333
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=149819