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

Thanks.
--
Brevity is the soul of wit.


"Gary''s Student" wrote:

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


etc.



--
Gary's Student
gsnu200702


"Dave F" wrote:

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
--
Brevity is the soul of wit.