Hello,
I like to create the CellAbove named range.
This is a cell-relative named range that refers to the "cell above" and can be used in formula such as sum(A1:CellAbove).
The problem: for a cell-relative named range to work, it needs to be worksheet-specific (just like the Print_Zone name, which is worksheet-specific i.e. works only for the worksheet it's been added to) .
The only way I found to create a worksheet-specific name is using VBA (this particular code add CellAbove to each sheet in the workbook):
Question: is it possible to create a worksheet-specific named range without using VBA ?
Thanks!
Louis
I like to create the CellAbove named range.
This is a cell-relative named range that refers to the "cell above" and can be used in formula such as sum(A1:CellAbove).
The problem: for a cell-relative named range to work, it needs to be worksheet-specific (just like the Print_Zone name, which is worksheet-specific i.e. works only for the worksheet it's been added to) .
The only way I found to create a worksheet-specific name is using VBA (this particular code add CellAbove to each sheet in the workbook):
Code:
Sub AddCellAbove()
Dim Sh As Worksheet
For Each Sh In Worksheets
Sh.Names.Add Name:="CellAbove", RefersToR1C1:="='" & Sh.Name & "'!" & "R[-1]C"
Next
End Sub
Question: is it possible to create a worksheet-specific named range without using VBA ?
Thanks!
Louis