Thread
:
Macro help
View Single Post
#
5
Posted to microsoft.public.excel.programming
Dana DeLouis[_3_]
external usenet poster
Posts: 690
Macro help
Oops! Just noticed the typo. The differences are 6, not 2.
Range("63:147").EntireRow.Hidden = True
k = CLng(Range("L62"))
Select Case k
Case 1 to 14
Row(63:63).Resize(6*k).Hidden = False
End Select
Dana DeLouis
<snip
Reply With Quote
Dana DeLouis[_3_]
View Public Profile
Find all posts by Dana DeLouis[_3_]