I am using the following code to check data is entered in certain cells...
I want to check a range of cells (C6:C8 in this instance) with the same msg box if no data entered in any one of three cells. I know I could repeat the code above but i guess there is a way of checking a range instead of repeating code?With Range("C6") If .Value = "" Then MsgBox "Not all Handicap Prices Are Entered." .Select Exit Sub End If End With
Bookmarks