Run-time error '91': - Object variable or With block variable not set (HELP!)

Hi All,

I thought I had completed a spreadsheet I've spent months working on when I have started seeing an error when I run a macro

Run-time error '91':

Object variable or With block variable not set
===========

It seems to work correctly when i run it at work, but I dont believe anything has changed.

This is one of the macro codes where I see the error

Please Login or Register  to view this content.

The : c = r.Find(S).Column being highlighted yellow

Anyone able to shed some light on this please?

Darren

A bit of a beginner, so took a guess at amending to the following code

Please Login or Register  to view this content.

Now got a 424 object required error

with the Set C = r.Find(S) highlighted,

Sorry to be a pain.

Darren

You messed up your code a bit
This should work:

Please Login or Register  to view this content.