MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Beginner needs help stopping a macro


Posted by Jack R on November 13, 2000 4:10 PM

I use if statements to copy different area. I need an if statement to stop the macro if a cell value =0.
all help appreaciated.


Posted by DoughBoy on November 13, 2000 10:00 PM

exit sub
or
end


Posted by Jack on November 14, 2000 7:08 AM


Thanks for the help. The "exit sub" worked. For some reason I couldn't get "end" to work.