Debug

**Cheetahslg** · 12-28-2006, 08:36 PM

I have run into a problem that says this...

Debug error #91

Object variable or w/block variable not set.

Can anyone tell me what that means?

Here is what it says in the visual basic....

Cells.find(What:="Grand Totals:", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, _
MatchCase:=True).Activate

**MSP77079** · 12-29-2006, 12:26 AM

It means it did not find "Grand Totals:".

Try this instead:

Please Login or Register  to view this content.

**Cheetahslg** · 12-29-2006, 01:41 PM

It has it in the macros to replay "totals" w/"Grand Total" Totals are there, but for some reason it is not picking up the totals.

Is there anyway I can skip/ignore it so it can finish running my other reports?