Find & Replace on Workbook Open - Error Method 'Cells' of object'_Global' failed

Hi,

I recorded a macro to be used on Workbook Open which finds and replaces blank looking cells to truly make them blank. However, I keep getting the following error:

Run-time error '1004':
Method 'Cells' of object '_Global' failed

Does anyone know what the issue is with my code & what a possible solution might be?

Please Login or Register  to view this content.

Thanks for any help on this!

Thanks for the response.

Just FYI, In my initial code, I was receiving an error on these lines of text:

Please Login or Register  to view this content.

I've tried using your code, and am unfortunately still receiving the same error on this line:

FndRng.Select

After I made the file into a sample workbook I realized that this error is only occurring on my actual file, which is located on a Sharepoint Team Site. The second I move the file locally, the error magically goes away...

For what it's worth, I've attached the sample file. It works perfectly fine, so making a before/after page won't really help since the code will fix the "before" worksheet anyway.

The main problem is now that my code for some reason is not working on the actual file on the internet. Maybe this topic doesn't belong in this thread since it's a different problem than I first thought


Samplebook_2.xlsm