named range with filter
On Mon, 17 Oct 2005 03:20:03 -0700, dee
wrote:
hi,
Can you create a named range (using offset) and include a filter in this
named range?
thanks
You can use either Insert Name Create or Insert Name Define.
With text "TEST1" in A1, highlight A1:D5 choose Insert Name Create and
select Top row and Left column. This sets the range name Test1 to
A2:D5 .
Insert Name Define, Name = "Test2", type the following in the Refers
to box:
=OFFSET(Sheet1!$A$10:$D$15,0,0):OFFSET(Sheet1!$A$1 0,5,5)
This sets the range name "Test2" to A10:F15
Better still just select the range you're interested in and type the
name you want, in the Name box immediately above the column A heading.
I can see no reason why filters won't work with these ranges.
HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
|