Runtime error 91 - Object variable or with block variable not set

[Christian411]

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?

Please Login or Register  to view this content.

Thanks,

Chris

[Andy Pope]

Did CurRng1 actually find anything?

Try testing it for nothing before using it.

[rwgrietveld]

Replace this into your code

Please Login or Register  to view this content.

The old

Please Login or Register  to view this content.

also comes in handy

You may Find this Nothing LOL
Sorry for this poor translation from Dutch.