S
stew0720
I'm trying to tell good 'ole Excel to start at B3, then go down the
column and find the next row with the value of "Address" in column B
WITH an empty cell next to it in Column C. In other words, I've got a
data entry userform, and I'm trying to located the next empty form
(they all start with "Address").
I'm aware that the following code will find the next empty cell:
Do
If IsEmpty(ActiveCell) = False Then
ActiveCell.Offset(1, 0).Select
End If
Loop Until IsEmpty(ActiveCell) = True
So I'm trying to do something like this:
If ActiveCell = "Address" And ActiveCell.Offset(0, 1) Is Not Null Then
ActiveCell.Offset(1, 0).Select
End If
ActiveCell = "Address" And ActiveCell.Offset(0, 1) Is Null
But that's nowhere near correct i guess. Any ideas?
column and find the next row with the value of "Address" in column B
WITH an empty cell next to it in Column C. In other words, I've got a
data entry userform, and I'm trying to located the next empty form
(they all start with "Address").
I'm aware that the following code will find the next empty cell:
Do
If IsEmpty(ActiveCell) = False Then
ActiveCell.Offset(1, 0).Select
End If
Loop Until IsEmpty(ActiveCell) = True
So I'm trying to do something like this:
If ActiveCell = "Address" And ActiveCell.Offset(0, 1) Is Not Null Then
ActiveCell.Offset(1, 0).Select
End If
ActiveCell = "Address" And ActiveCell.Offset(0, 1) Is Null
But that's nowhere near correct i guess. Any ideas?