I recorded a macro which worked the first time but now it get an error - error 91 - 'object variable or with block variable not set'
Cells.Find(What:="Sheet No :", After:=ActiveCell, LookIn:=xlValues, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
I just can't figure out what is causing the error. I recorded a new macro which again runs the first time and then gets the error.