You need to include "error handling" code into the Macro;
Probably best if you copy and paste the macro into this thread,
then someone can review it, and modify it for you << to do so will
affect
2,3 or 4 lines of new code..

Jim



"ChrisMattock"
wrote in
message news:ChrisMattock.2ae23z_1151962203.0641@excelforu m-nospam.com:

Hey I have a spreadsheet that has a macro to populate a word document,
its all a bit complicated but if a certain cell isnt filled out a
runtime error occurs when the macro is run. Is there a way of instead
of this error coming up a dialogue box appears and the macro is exited?
if there is not a simple way of doing this then I will post more
details...


--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile: http://www.excelforum.com/member.php...o&userid=33912
View this thread: http://www.excelforum.com/showthread...hreadid=557935