Hi Mr. Carey! Thanks for the input on this conundrum. I
did work on a copy of my original master file but the
master file has NO formulas on it yet and the copy has the
first template almost done but with this problem. Would
love to run your code but usually work in Access and don't
know where/how to run code in Excel. Just never done it.

Thanks again for your participation in the newsgroups
helping folks out! LUV U GUYS!

-----Original Message-----
I did a very quick test and this VBA code seemed to deal
with what's ailing
you. Make sure you work on a copy of your file this
time, ok!

Sub DeleteApostrophes()
Dim cc As range
Dim str As String

For Each cc In selection
str = cc.Formula
If Len(str) 0 Then
If cc.Value = str And Left(str, 1) = "=" Then
cc.Formula = str
End If
End If
Next
End Sub

Good luck


"Bonnie" wrote:

Hi there! Using E02 on XP. Have zillions of formulas to
create and if I can get my template going, it will be
much
easier. Only problem is this: I used Replace to change
all
my ='1'!'s with '=1'1! so I can see my formulas and use
copy/replace to create my boiler templates on multiple
worksheets. I have done this in the past and then just
replace in reverse and voila! I have formulas linked to
the correct worksheet locations. This time I keep
getting
the Excel can't find anything to replace, check your
formating, etc.

What am I doing wrong? I really do not want to key in
10
sheets of formulas.

Here is what my cell reads: '='1'!M68
My formula would be: ='1'!M68

Is it because I have used a number for the worksheet
name?
I've played with it but can't fix it. Tried reformating
the cells, etc.

Would really appreciate any help or advice on this
before
I wear my fingers down to nubs and get sheetsick.
Thanks a
bunch for your time!

.