Guys,

I have the following code:

If Range("AM58").Value 0 Then Range("AT2").Value = "DATA MISSING",
MainMenu.Hide, Call Main_Menu

If Range("AM85").Value 0 Then Range("AT2").Value = "DATE FAULT",
MainMenu.Hide, Call Main_Menu

If Range("AM62").Value 0 Then Range("AT2").Value = "WRONG/CORRUPT
FILE", MainMenu.Hide, Call Main_Menu


and cant get the syntax to work (I know thats bad ;)

What I need is the If to evaluate the condition and if its TRUE then it
has to execute the 3 commands after the Then.
I know the commas are wrong but its for illustration.

I tried to block them and use else ifs and cant get it to work

Help appreciated :)

Matt