Hi,
I pasted the code into a new mudule. When I ran it the debugger popped
up saying 'Compile Error: Expected End Sub'
So I add end sub to the end of the code. But when I ran the macro again
it said - 'Compile Error: For without Next' and the end sub line was
highlighted.
Could you help me out?
Thanks,
Mark.
--
mevetts
------------------------------------------------------------------------
mevetts's Profile:
http://www.excelforum.com/member.php...o&userid=29130
View this thread:
http://www.excelforum.com/showthread...hreadid=497252