M Michelle Sep 26, 2003 #1 Is there any way to export a named range from formulas to values on another worksheet? help please!!! Thanks.
Is there any way to export a named range from formulas to values on another worksheet? help please!!! Thanks.
S Sequoia D. Schroeder Sep 26, 2003 #2 1. GoTo (CTRL+G) NamedRange 2. Copy (range will be selected) 3. Switch to other worksheet 4. Edit, Paste Special, Values - Sequoia ------- note: e.mail above is closed due to excessive spam/viruses resulting from posting it to this forum previously. if you wish to e.mail me sequoia UNDERSCORE s AT yahoo DOT com humans can figure that out ... spambots should choke on it.
1. GoTo (CTRL+G) NamedRange 2. Copy (range will be selected) 3. Switch to other worksheet 4. Edit, Paste Special, Values - Sequoia ------- note: e.mail above is closed due to excessive spam/viruses resulting from posting it to this forum previously. if you wish to e.mail me sequoia UNDERSCORE s AT yahoo DOT com humans can figure that out ... spambots should choke on it.
