View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default macro to save named range as text

How about creating a new sheet, copy the named range to that sheet, then
saving it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"GFN" wrote in message
...
Is there a way to save a named range as a text file. I have only found

how
to save a worksheet as a text file.