I ill-advisedly added ' before a bunch of formulas because I wanted to move
the formulas between workbooks and have them reference the current workbook.
I thought that I would be able to find and replace the ' from the formula but
I am having trouble doing that. (I Believe it is char(39) FYI).

Does know of a way to remedy this.

Thanks,