Export as values

M

Michelle

Is there any way to export a named range from formulas to
values on another worksheet? help please!!! Thanks.
 
S

Sequoia D. Schroeder

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.
 
Top