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!
|