referencing named ranges in VBA

[Guest]

I have the following macro, which hides and unhides some rows:

Sub ShowMWDC()
' Freezes window at cell A41
' Unhides rows 41:83
' Hides rows 2:39
Cells.Select
Range("B1").Activate
Selection.EntireRow.Hidden = False
Selection.EntireColumn.Hidden = False
Rows("41:83").Select
Selection.EntireRow.Hidden = False
Rows("2:40").Select
Selection.EntireRow.Hidden = True
Range("A44").Select
ActiveWindow.FreezePanes = False
ActiveWindow.FreezePanes = True
End Sub


Rows 41:83 correspond to a named range, "MWDC" and rows 2:40 correspond to a
named range, "Migration". How would I modify the above to use these named
ranges as opposed to the rows?

Thanks,

Dave

 

[Dave O]

Hi, Dave-
Try this one:
Range(Names("MWDC").RefersTo).Select

Dave O

 

[Guest]

Just replace
Rows("41:83").Select
with
Range("MWDC").Select


etc.

 

[Dave O]

Gary's kung fu is better: I'm going to change my code archive.

 

[Guest]

Well that's easy. Probably should have tried that one on my own.

Thanks.

 

[Guest]

The key point is that the name of a named range is just a string, not a
variable. A very common mistake is to use
Range(MWDC)
instead of
Range("MWDC")