same range name in different sheets
If you were interested in doing this programmatically, you could do
something like this:
Dim i As Long
For i = 1 to Worksheets.Count
Worksheets(i).Names.Add Name:="salesmonth1", RefersToR1C1:= "=" &
Worksheets(i).Name & "!R5C2:R18C5"
Next i
In the end, cells B5:E18 of each worksheet would be named
"salesmonth1"
--JP
On Nov 26, 3:03 am, "Gilbert DE CEULAER"
wrote:
I have several sheets in the same workbook (e.g. year1, year2, year3,...).
I would like to name the same range in every sheet by the same name (e.g.
salesmonth1)
Is there a way to do this "in one move", I mean without going from sheet to
sheet.
Thanks in advance
Gilbert
|