mysticmario
Active Member
- Joined
- Nov 10, 2021
- Messages
- 323
- Office Version
- 365
- Platform
- Windows
as per title.
I have similar code in different part of my workbook and it works fine, but as soon as i started playign with offsets I have this problem.
I assume i need some more stuff to make it work.
I have similar code in different part of my workbook and it works fine, but as soon as i started playign with offsets I have this problem.
VBA Code:
Sub TEST()
ActiveSheet.Columns("D:D").Select
Set cell = Selection.Find(what:="legs", After:=ActiveCell, LookIn:=xlFormulas, _
lookat:=xlPart, SearchOrder:=xlByRows, searchdirection:=xlNext, _
MatchCase:=False, SearchFormat:=False)
If Not IsEmpty(cell.Offset(, 2)) And cell.Offset(, 2) <> 0 Then
MsgBox "no legs"
Else
MsgBox "yes legs"
End If
End Sub