I'm putting a check into some code to make sure certain range, all the cells equal 100%
My code is as follows;
When i run the code i get an error of type mismatch?![]()
'Check N&O rates are 100% If Worksheets("N&O Rates").Range("J3:J23").Value <> "100" Then MsgBox "Please populate the N&O Rates - macro stopped" Exit Sub End If
Bookmarks