NicholasP
Active Member
- Joined
- Nov 18, 2006
- Messages
- 291
Hi all, I have this bit of code that is not working and I do not know w
It loops through the cells just fine, but on the first error it encounters, it breaks. I checked the immediate window; IsError(Cells(tp_rw_dte, 4)) does indeed equal true.
Any help would be greatly appreciated.
Thanks
Nick
Code:
Do
If IsError(Cells(tp_rw_dte, 4)) = False Then
tp_rw_dte = tp_rw_dte + 1
End If
Loop Until IsError(Cells(tp_rw_dte, 4)) = True Or Cells(tp_rw_dte, 4) = ""
It loops through the cells just fine, but on the first error it encounters, it breaks. I checked the immediate window; IsError(Cells(tp_rw_dte, 4)) does indeed equal true.
Any help would be greatly appreciated.
Thanks
Nick