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
|