Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I tried to figure out how to do this but I'm stumped! I have a worksheeet where I have defined a set of names and values like H2_gas =34356.87 O2_gas=14523.14 I do this by using "DefineName" and directly typing the name and the value it should stand for. Essentially these are constants and don't change. I just needed a convinient way to refer to them. Now I am starting a new workbook where I'd like to be able to refer to these values. Whats a neat way to do this? If possible I wanted to have them redifined as constants and not as cell refernces(just as I had done manually in the original worksheet) to avoid the chance of inadverent changes at some later date... ANy sugesstions? Thanks! -Rahul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cannot copy from one workbook to another | Excel Discussion (Misc queries) | |||
Copy sheet to new workbook | Excel Discussion (Misc queries) | |||
What's the simplest way to copy data from another workbook | Excel Worksheet Functions | |||
copy COLUMN from 1 worksheet to another (in a different workbook) | Excel Discussion (Misc queries) | |||
copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions |