Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automating the Creation of Userforms in VBA | Excel Programming | |||
Help with automating creation of Pie Chart(s) | Charts and Charting in Excel | |||
Mass Creation of Named Ranges? | Excel Programming | |||
Mass Creation of Named Ranges? | Excel Discussion (Misc queries) | |||
Automating hyperlink creation | Excel Worksheet Functions |