View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ashwinv@gmail.com is offline
external usenet poster
 
Posts: 2
Default Programatically increase the size of all named ranges

Hi,

I have about 25+ named ranges in my excel workbook. All of these ranges
currently end at row 250 and I want to increase this to 1500 for all
ranges. How do I do this programatically?

Any help is deeply appreciated.

Thanks,
Ashwin