Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Names
I decided to simplify a spreadsheet by naming some columns, but messed
up and only named the particular cells I was working on. I tried to create a new range with the same name, but was told that the name already existed. 1. How do I delete that old name? 2. Can I give a name to a column without giving that column a range? 3. If so, how do I replace, say =IF(H660,F66-I66-K66-H66,"") with meaningful names, for instance net=gross-labor-depreciation-tax? (each field is referenced multiple places for that row). -- "In no part of the constitution is more wisdom to be found, than in the clause which confides the question of war or peace to the legislature, and not to the executive department." - James Madison |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting email address names in a range of cells to real names | Excel Worksheet Functions | |||
using the Excel generic worksheet names instead of user-given names in code | Excel Discussion (Misc queries) | |||
how to copy workbook names and worksheet names to columns in acces | Excel Programming | |||
Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
Change names of files in a folder to match names in Excel Column | Excel Programming |