Cartillo
asked on
Unhide Rows
Hi Experts,
I would like to request Experts help. The attached script has been used to Hide and Unhide rows at Week1 to Week5 Sheets. The macro should be able to display all time value at Column A (00:00 to 23:55) if click the "Unhide" sub, however few rows especially after 23:00 are still hidden. Hope Experts would help to fix this problem. Attached the workbook for Experts perusal.
Unhide-Rows.xls
I would like to request Experts help. The attached script has been used to Hide and Unhide rows at Week1 to Week5 Sheets. The macro should be able to display all time value at Column A (00:00 to 23:55) if click the "Unhide" sub, however few rows especially after 23:00 are still hidden. Hope Experts would help to fix this problem. Attached the workbook for Experts perusal.
Unhide-Rows.xls
ASKER
Hi VipulKadia,
Need you help. Is that possible to delete all data at Range("B4:H291") and color fill? At the same time Wrap text and Center text. Hope you will consider this request.
Need you help. Is that possible to delete all data at Range("B4:H291") and color fill? At the same time Wrap text and Center text. Hope you will consider this request.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi VipulKadia,
Thanks for the help
Thanks for the help
Sub UnhideRows()
Dim ws As Worksheet
Dim I As Long
For I = 1 To 5
Set ws = Worksheets("Week" & I)
ws.Rows.Hidden = False
Next I
End Sub