Run-time error '91' Object variable or With block variable not set

[joherszch]

Anyone know the solution to this problem?

Please Login or Register  to view this content.

[JOHN H. DAVIS]

What are you trying to accomplish?

[joherszch]

I am trying to remove non-compatible symbols in the cells before saving the file. The cell C1:D1 is merged, so I think it might has to do something with that.

[Norie]

Why are you using Find?

[joherszch]

I was unable to get it to work with a formula like

Please Login or Register  to view this content.

so I recorded a macro with CTRL+H to get rid of the symbols. If there is any other way to do this I would appreciate any solutions!

I want to do the the following changes:
Remove C1 value: "Subject:" but let the rest of the cell value that follows to remain untouched.
Change D2 value: "No: 0.1" TO "Part-0-Test-1" and the 0 and 1 needs to be untouched.

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[joherszch]

Worked like a charm! Thank you very much JOHN H. DAVIS!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.