I'm fairly sure I saw this yesterday somewhere in this forum, but after
almost two hours of searching, and not finding, I figure I've earned
the right to ask - if only because someone should feel sorry for my
pathetic search skills (or bad memory).

Example: say I have a formula =$A$1+$B$2. Later, I name cell A1
"start" and B2 "finish". The original formula above still has the cell
references and not the cell names (it does not change to
=start+finish).

How can I get the formulae created prior to naming cells to change and
reflect the cell names?

Secondly, given that I have hundreds of formulas to which this would
apply, is there some way to do this globally or will I need to go cell
by cell?

Thanks,

Hector


---
Message posted from http://www.ExcelForum.com/

Edit / Replace / Replace what = $A$1, Replace with = Start will do all cells
that refer to A1

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"hdf >" <<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I'm fairly sure I saw this yesterday somewhere in this forum, but after
> almost two hours of searching, and not finding, I figure I've earned
> the right to ask - if only because someone should feel sorry for my
> pathetic search skills (or bad memory).
>
> Example: say I have a formula =$A$1+$B$2. Later, I name cell A1
> "start" and B2 "finish". The original formula above still has the cell
> references and not the cell names (it does not change to
> =start+finish).
>
> How can I get the formulae created prior to naming cells to change and
> reflect the cell names?
>
> Secondly, given that I have hundreds of formulas to which this would
> apply, is there some way to do this globally or will I need to go cell
> by cell?
>
> Thanks,
>
> Hector
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.576 / Virus Database: 365 - Release Date: 30/01/2004

Thank you.

I was hoping there would be a simpler way to do it than the search and
replace approach. Since I have hundreds of cell names that I would
like to do this for, it could be quite a tedious task.

Is there another solution available?


---
Message posted from http://www.ExcelForum.com/

A bit dangerous, Ken; $A$15 will be converted to Start5

Use Insert>Name>Apply instead

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Ken Wright" <(E-Mail Removed)> wrote in message
news:ur7$(E-Mail Removed)...
> Edit / Replace / Replace what = $A$1, Replace with = Start will do all
cells
> that refer to A1
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 00/02/03
>
> --------------------------------------------------------------------------
--
> It's easier to beg forgiveness than ask permission :-)
> --------------------------------------------------------------------------
--
>
>
>
> "hdf >" <<(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > I'm fairly sure I saw this yesterday somewhere in this forum, but after
> > almost two hours of searching, and not finding, I figure I've earned
> > the right to ask - if only because someone should feel sorry for my
> > pathetic search skills (or bad memory).
> >
> > Example: say I have a formula =$A$1+$B$2. Later, I name cell A1
> > "start" and B2 "finish". The original formula above still has the cell
> > references and not the cell names (it does not change to
> > =start+finish).
> >
> > How can I get the formulae created prior to naming cells to change and
> > reflect the cell names?
> >
> > Secondly, given that I have hundreds of formulas to which this would
> > apply, is there some way to do this globally or will I need to go cell
> > by cell?
> >
> > Thanks,
> >
> > Hector
> >
> >
> > ---
> > Message posted from http://www.ExcelForum.com/
> >
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.576 / Virus Database: 365 - Release Date: 30/01/2004
>
>

Select the cells with the formulas
Choose Insert>Name>Apply
Select the names you want to apply
Click OK

hdf < wrote:
> I'm fairly sure I saw this yesterday somewhere in this forum, but after
> almost two hours of searching, and not finding, I figure I've earned
> the right to ask - if only because someone should feel sorry for my
> pathetic search skills (or bad memory).
>
> Example: say I have a formula =$A$1+$B$2. Later, I name cell A1
> "start" and B2 "finish". The original formula above still has the cell
> references and not the cell names (it does not change to
> =start+finish).
>
> How can I get the formulae created prior to naming cells to change and
> reflect the cell names?
>
> Secondly, given that I have hundreds of formulas to which this would
> apply, is there some way to do this globally or will I need to go cell
> by cell?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Oops - Cheers Niek - Should have thought of that one.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Niek Otten" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> A bit dangerous, Ken; $A$15 will be converted to Start5
>
> Use Insert>Name>Apply instead
>
> --
>
> Kind Regards,
>
> Niek Otten
>
> Microsoft MVP - Excel
>
> "Ken Wright" <(E-Mail Removed)> wrote in message
> news:ur7$(E-Mail Removed)...
> > Edit / Replace / Replace what = $A$1, Replace with = Start will do all
> cells
> > that refer to A1
> >
> > --
> > Regards
> > Ken....................... Microsoft MVP - Excel
> > Sys Spec - Win XP Pro / XL 00/02/03
> >
> > --------------------------------------------------------------------------
> --
> > It's easier to beg forgiveness than ask permission :-)
> > --------------------------------------------------------------------------
> --
> >
> >
> >
> > "hdf >" <<(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > I'm fairly sure I saw this yesterday somewhere in this forum, but after
> > > almost two hours of searching, and not finding, I figure I've earned
> > > the right to ask - if only because someone should feel sorry for my
> > > pathetic search skills (or bad memory).
> > >
> > > Example: say I have a formula =$A$1+$B$2. Later, I name cell A1
> > > "start" and B2 "finish". The original formula above still has the cell
> > > references and not the cell names (it does not change to
> > > =start+finish).
> > >
> > > How can I get the formulae created prior to naming cells to change and
> > > reflect the cell names?
> > >
> > > Secondly, given that I have hundreds of formulas to which this would
> > > apply, is there some way to do this globally or will I need to go cell
> > > by cell?
> > >
> > > Thanks,
> > >
> > > Hector
> > >
> > >
> > > ---
> > > Message posted from http://www.ExcelForum.com/
> > >
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.576 / Virus Database: 365 - Release Date: 30/01/2004
> >
> >
>
>


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.576 / Virus Database: 365 - Release Date: 30/01/2004