Thread: increasing the size of a named range and saving it back to the spreadsheetI
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Hansen Rick Hansen is offline
external usenet poster
  
Posts: 104
Default increasing the size of a named range and saving it back to the spreadsheetI
Ross Try

Range("Print_Area").Resize(, 1 + Range("Print_Area").Columns.Count).Name =
"RangeName"

enjoy , Rick


wrote in message
oups.com...
Hi, I have figured out how to increase the range: Set tRange =
Range("Print_Area").Resize(, 1 + Range("Print_Area").Columns.Count).

But now that I have my new range, how can i save the spreadsheet and
save the new range?

Thanks.



Reply With QuoteReply With Quote