Cell Naming and Formula bar Display
 

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...
--
Regards,
Adrian

Cell Naming and Formula bar Display
 

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

Check in InsertNameDefine...

--

HTH

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

"Adrian" wrote in message
...
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...
--
Regards,
Adrian