multiple if statements

Hi All,

i am creating some error checking on a template of mine and i need to have a code that runs a bunch of if statements and exits if it doesnt meet the criteria at any step of the process, and the end result if it passes all criteria is 'msgbox go' but i cant seem to get it right - excel 2007

Please Login or Register  to view this content.

where do the endif's go because ive tried seperating them all into seperate if statements and also putting all the end ifs at the end and none of which seem to work.

if i separate them out then it runs but doesnt do anything..

Its fine ive figured it out, i separated them into different subs, then created a new sub to call them all, works fine

Thanks for your help

try this

Please Login or Register  to view this content.

Thanks lancer, mine just ran the statements but didnt actually stop the if statements, your code is exactly what i was looking for!