Re: Rename Cell Name

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: JulieD (JulieD_at_hctsReMoVeThIs.net.au)
Date: 11/11/04 

Date: Fri, 12 Nov 2004 01:00:01 +0800

Hi

okay then, if you have a name StartCell and it refers to cell A1 and you've
used it in formulas e.g.
=StartCell+B1 or whatever
then
do a edit / replace
find: StartCell
replace with: A1
replace all
this will change the above formula to
=A1+B1
you can then delete the name.

Cheers
JulieD
PS do on a copy of your workbook first and check it - i only checked it on a
few types of formulas.

"DragonYian" <DragonYian@discussions.microsoft.com> wrote in message
news:CB24F723-2A47-4A53-AAB1-8A5AB972BAD5@microsoft.com...
> Dear JulieD,
> i cant delete the name by using the method you used, you know why? is that
> because that name was referring bu other cell in the calculation?
> Regards
> Dragon
>
> "JulieD" wrote:
>
>> Hi Dragon
>>
>> go into insert / name / define - you can delete the name there and create
>> another if you wish.
>>
>> Cheers
>> JulieD
>>
>> "Dragon" <Dragon@discussions.microsoft.com> wrote in message
>> news:B6A6510E-0233-4B2A-8A0C-F16F73585CBA@microsoft.com...
>> > hey all, i have change the cell anem from A1 to StartCell. Bu, how can
>> > i
>> > rename it back to A1 or change it to another name?
>> > Thanks in advance
>> > Regards
>> > Dragon
>> >
>>
>>
>>

Relevant Pages

  • Dragons
    ... PAOLO FRIL, chairman and chief scientific officer of GeneDupe, ... Virtual cell biology aspires to make a software ... GeneDupe's scientists can ... Each computer starts with a search image (dragon, unicorn, ...
    (soc.retirement)
  • Re: Dragons, again...
    ... For something a bit more up to date on dragon possibilities ... Biology and computing have a lot in common, ... Virtual cell biology aspires to make a software ... The virtual genomes of these real animals are ...
    (rec.arts.sf.science)
  • RE: Create Detail Sheets from Pivot Table
    ... excluding the first and last cell that meet this criteria. ... Dim PasteTab As String ... Dim StartCell As Variant ... ActiveCell.FormulaR1C1 = "Average Drive Time" ...
    (microsoft.public.excel.programming)
  • Re: Re: Copying a variable range
    ... ~>If I'm running the macro, ... ~>dim startcell as range ... ~>> blank) for the receiving cell and start the macro there filling in the ... ~>> remaining blank rows which are counted by the offset counting cell. ...
    (microsoft.public.excel.misc)
  • Re: moving rows into columns
    ... I just found the cell. ... Dim StartCell As Range ... Dim DestCell As Range ...
    (microsoft.public.excel.programming)