Run-time error 91 - Object variable or with block variable not set

[twckfa16]

Hello -

I received a snippet of code today that works fine by itself - but then I try to combine it into the whole project I get the '
run-time error 91. Highlighted in red is the code I received today...and in bold is where the run-time error is occurring
(.Formula line)

Thanks,

Please Login or Register  to view this content.

[Norie]

If there's no data in column M of the active sheet you will get the error you describe.


Is the sheet you want to run that piece of code on active?

[twckfa16]

Not sure - I think I tried to actvate that sheet but was getting the same error.

[Norie]

What sheet should the code be run on?

Whatever it is try replacing ActiveSheet with an explicit reference to it.

[twckfa16]

It should be run on sheet 1...should it be something like this:

Please Login or Register  to view this content.

[Norie]

If the worksheet the code is to run on has the codename Sheet1 that code should work.

[twckfa16]

Hello - seem to be struggling with this. I have changed the code to this:

Please Login or Register  to view this content.

[Norie]

Why did you change it to that?

That code won't work for a number of reasons.

Did substituting Sheet1 for ActiveSheet not work?

[twckfa16]

I did it based on somethign I did in another sub...i changed it back to the below and get the same error 91:

Please Login or Register  to view this content.

[Norie]

What's the name of the worksheet?

Can you attach a sample workbook?

[twckfa16]

Sure - here you go:


Column F should be the new column E after running macro.

Thanks

[Norie]

This line of code is looking for data in column M, not E or F.

Please Login or Register  to view this content.

In the workbook you attached there's no data in column M.

[twckfa16]

Ok...can you take a look at this file which works...it's essentially the same code as
the other file

Thanks

[Norie]

Is there a problem with the file?