View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jon Tillman Jon Tillman is offline
external usenet poster
 
Posts: 6
Default Automatically define series of named ranges

I have a sheet that has several hundred rows. I would like to start at
row 1, select the range from 1 to 13, create a named range from it,
then move to row 2 and repeat, throughout the sheet, until there are
no more 13 row ranges possible. How on earth would I go about doing
this?