Hi guys,
The following is an extract from quite a large macro. This part (more specifically the line CurRng2=CurRng1.Offset(1,0)) is generating the error "Object variable or with block variable not set". Can anyone explain why?
SlotNo1 = InputBox("Slot to be Inserted After Slot?", "Engine Slot")
Set CurRng1 = Range("B9:B200").Find(What:=SlotNo1, After:=Range("B9"), LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False)
CurRowNo1 = CurRng1.Row
CurRng2 = CurRng1.Offset(1, 0)
CurRowNo2 = CurRowNo1 + 1
CurRng2.Select
Thanks,
Chris
Bookmarks