View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stephen[_24_] Stephen[_24_] is offline
external usenet poster
 
Posts: 83
Default Automating creation of named ranges???

Hi Folks,

I'm have 52 sheets named 1,2,3,etc., that I want to create named ranges on
in the following fashion...

sheet 1 (named "1") has A:C named w1s
sheet 1 (named "1") has D:F named w1c

sheet 2 (named "2") has A:C named w2s
sheet 2 (named "2") has D:F named w2c

.... all the way down the line.

Is there a simple way to slap together a one-time use macro so I don't have
t odo this all manually?

Thanks in Advance!