Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unhiding Rows
Hi Ruan:
Your first version should work fine unless the worksheets are protected. The second version will not work as the syntax is incorrect. Also, using the EntireRow property is unnecessary as the ranges are already entire rows. Regards, Vasant. "Ruan" wrote in message ... Hello, I am trying to unhide rows to 2 Worksheets, but without activating the 2nd Worksheet. I have used both of the codes below, but get a the following error "Run-time error '1004' Unable to set the hidden property of the range class" ' Unhide All Rows on the Worksheet Worksheets("Billing1").Rows("1:1010").EntireRow.Hi dden = False Worksheets("Billing2").Rows("1:1010").EntireRow.Hi dden = False or With Worksheets("Billing1") & Worksheets("Billing2").Rows("1:1010") .EntireRow.Hidden = False End With What am I doing wrong? Thanks Ruan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hiding/unhiding rows | Excel Worksheet Functions | |||
Unhiding Rows | Excel Discussion (Misc queries) | |||
Unhiding rows | Excel Discussion (Misc queries) | |||
Unhiding rows in Excel | Excel Worksheet Functions | |||
unhiding rows automatically | Excel Worksheet Functions |