I'm writting some VBA code in excel; I have a Select Case loop which (using a count function) works its way down one column of cells. Within the Select Case I want one case to check if the cell is blank which would cause the sub to end i.e.
case a: do this
case b: do that
case (blank cell): exit sub
How to I write (blank cell) in this form?
Cheers
case a: do this
case b: do that
case (blank cell): exit sub
How to I write (blank cell) in this form?
Cheers