Thread: Named Range?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Named Range?

How about:

Sub dural()
If ActiveCell.Address = "$B$6" Then Range("myrange").EntireRow.Hidden = False
End Sub

where myrange is defined on the worksheet with:

Insert Name
--
Gary''s Student - gsnu200834


"Martin" wrote:

Hello,

I have this code on the followhyperlink:

If ActiveCell.Address = "$B$6" Then Rows("11:110").EntireRow.Hidden = False

The rows 11 to 110 may change so I want to use named ranges but when I name
this range the code doesnt work. Is there a different way to reference the
named range?

Thanks in advance.

Martin