I am also using E02 on XP
I copied your equation into my computer
did find and replace and had no problems

does find and replace work correctly on other things for you?

are you really using the '=1'1! or just '=1'!


"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!

bj -

I'm running E02 on Win2K and I've never been able to get rid of the leading
apostrophe using Find & Replace. Like the OP, I get a message that no
matching data could be found.

Wonder what's different in your setup than in mine.



"bj" wrote:

I am also using E02 on XP
I copied your equation into my computer
did find and replace and had no problems

does find and replace work correctly on other things for you?

are you really using the '=1'1! or just '=1'!


"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!

I redid it to verify
if I am on the cell containing the text just having pasted the text, it does
replace it
If I am not it does not find it and will not replace it
if I move back to it, it will not replace it
???

"Duke Carey" wrote:

bj -

I'm running E02 on Win2K and I've never been able to get rid of the leading
apostrophe using Find & Replace. Like the OP, I get a message that no
matching data could be found.

Wonder what's different in your setup than in mine.



"bj" wrote:

I am also using E02 on XP
I copied your equation into my computer
did find and replace and had no problems

does find and replace work correctly on other things for you?

are you really using the '=1'1! or just '=1'!


"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!

Yes, BJ, it does work if you are on just one cell. I just
won't work on a selected area. VERY odd. I should have
used a text string rather than the text identifier. Dang!
Thanks very much for the input.

-----Original Message-----
I redid it to verify
if I am on the cell containing the text just having
pasted the text, it does
replace it
If I am not it does not find it and will not replace it
if I move back to it, it will not replace it
???

"Duke Carey" wrote:

bj -

I'm running E02 on Win2K and I've never been able to
get rid of the leading
apostrophe using Find & Replace. Like the OP, I get a
message that no
matching data could be found.

Wonder what's different in your setup than in mine.



"bj" wrote:

I am also using E02 on XP
I copied your equation into my computer
did find and replace and had no problems

does find and replace work correctly on other things
for you?

are you really using the '=1'1! or just '=1'!


"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!

.