Cell Naming and Formula bar Display

  • Thread starter Thread starter Adrian
  • Start date Start date
A

Adrian

Hi,
I have name a cell using the same VBA command as follows in 2
different
spreadsheets submitted by 2 different colleagues :


Spreadsheet A
*************
VBA Command Executed : Range("E4").Name = "Overall_CashBegining"

Cell Formula in E5 : "=E4"

Formula Bar Display when cell E5 is selected: "=E4"



Spreadsheet B
***********
VBA Command Executed : Range("E4").Name = "Overall_CashBegining"

Cell Formula in E5 : "=E4"

Formula Bar Display when cell E5 is selected: "=Overall_Cash Begining"


Why is there a different display in the formula bar despite the fact that
other
conditions are the same... only the spreadsheet were submitted by different
people. Is there any options to turn on/off cell naming in formula bar
display ?


Thanks...
 
Could it be that the cell also has a name of Overall_Cash Begining (defined
previously)?

Check in Insert>Name>Define...

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top