Kindly_Kaela
12-28-2006, 02:11 PM
I'm trying to hide rows in excel based on a VBA variable. The variable in my program is Days. Can someone help me make this work. This is what I tried...
Public Days As Single
Rows(Days:368).Select
Selection.EntireRow.Hidden = True
I'm confident Days is working as a variable, because I tested it with:
MsgBox Days
Thank you,
Kaela
:cloud9:
Public Days As Single
Rows(Days:368).Select
Selection.EntireRow.Hidden = True
I'm confident Days is working as a variable, because I tested it with:
MsgBox Days
Thank you,
Kaela
:cloud9: