Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display formula on the cell | Excel Worksheet Functions | |||
Display cell ref for MAX formula | Excel Discussion (Misc queries) | |||
Naming a Formula, using Link to Cell containing that Formula | Excel Discussion (Misc queries) | |||
Display formula in cell | Excel Discussion (Misc queries) | |||
cell naming not showing up in drop down list of formula bar | Excel Programming |