VBA error Expected then or goto

**sam94** · 02-19-2015, 07:46 AM

Hi ,

I am trying to use this VBA code to make a message box appear when the value in column G16:GX is > 0 and when in column M it says 'Yes'

If Range("G16:G10000").Value > 0 And
Range("m16:m10000") = "yes"

Then MsgBox "Please make sure you have got permission off the relevant product manager for this product"

End sub

Can anybody see what is wrong?

Sam

**bmouse** · 02-19-2015, 07:52 AM

Try putting THEN in the same row as IF

**HaHoBe** · 02-19-2015, 08:03 AM

Hi, Sam,

please have a look at Forum Rule#3 to understand why you are asked to apply code-tags to your procedure.

You would need to loop through the cells in the ranges as well or use CountIf as well and eiother put the code all in one line or add Then behind the comaprision and close with an End If as well.

Ciao,
Holger