Excel VBA - If Named Range not empty, then run code

[2Took]

Hi,

Need code to check if all cells in named range ABC are filled, and only then run the code further. Else, MsgBox "Must fill the cells"

Code gives below error:

If Range(ToFill) <> "" Then

The code is in the same workbook.
Code Sheet name is Sheet2. Tab name is different.

 

[steve the fish]

Heres a way:

For Each c In Range("ABC")
    If Len(c.Value) = 0 Then
        MsgBox "Fill All Cells"
        Exit Sub
    End If
Next