Why does the result in cell A1 return "2" even if there are no values in either of the B1 to B3 cells?
Dim rng As Range
Set rng = Range("$B$1:$B$3")
If IsEmpty(Range(rng.Address)) Then
Range("A1").Value = "1"
Range("A1").Value = "2"
I've tried including values in either cell b1, b2, or b3 but the results return 0 even if the cells were blank.