Thread: increasing the size of a named range and saving it back to the spreadsheetI
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ross_smith@csaa.com is offline
external usenet poster
  
Posts: 5
Default increasing the size of a named range and saving it back to the spreadsheetI
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