Svgmassive

asked on

# First blank in a non contiguous range

I am trying to find a formula/code to find the first blank in the range below.Thanks

$F$15:$F$20,$F$22:$F$27,$F$29:$F$34,$F$36:$F$41

$F$15:$F$20,$F$22:$F$27,$F

No need to iterate. You can use

```
Sub a()
Debug.Print Range("$F$15:$F$20,$F$22:$F$27,$F$29:$F$34,$F$36:$F$41").SpecialCells(xlCellTypeBlanks).Offset(, 1).Cells(1).Address
End Sub
```

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**
Open in new window