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?


--
stew0720
------------------------------------------------------------------------
stew0720's Profile: http://www.excelforum.com/member.php...o&userid=35687
View this thread: http://www.excelforum.com/showthread...hreadid=554741