Compile error reared its ugly head after I added an IF statement? :o(

[carlandtina02]

Hi There,

I have a bit of code that save the current sheet as a PDF, then uses the data in cells "B16,H8 and H10" to save as the file name.
I needed to ammend it to include cell H8, (which works fine) but I also added two IF statements with message boxes to make sure all three fields were filled.

The problem is that when I add the 2nd and 3rd IF statements I get a compile error but when I take them out it works?

I've had a 2 hour head scratch now but cant figure it out! :o(

Any pointers would be a godsend!!!

Kind Regards
Carl

Please Login or Register  to view this content.

[AB33]

Please use code tags with your code.
You have 3iffs and should end with 3 end iffs

Please Login or Register  to view this content.

[carlandtina02]

Yeah happy days, Thanks AB33.

I thought open and closed square brackets were the code tags? my mistake I'll look it up!

Thanks again
Carl