Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hid rows in a hidden sheet.
Hi,
I would like to hide few rows in range name created in a hidded sheet. I'm using this code: Sheets("ABC").Range("XYZ").Range(Cells(1, 1), Cells(5, 1)).EntireRow.Hidden = False This code work until the sheet ABC is Visible and Active. Is there a way to hide rows on a hidden sheet. I don't want to use: Sheets("ABC").Range("A1":"A5").EntireRow.Hidden = False Any help will be appreciated. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Column Auto Width and Hidden Rows | Excel Discussion (Misc queries) | |||
How Do I format an Excel sheet to have a 3D effecrt in rows? | Excel Worksheet Functions | |||
change excel row height without showing hidden rows | Excel Worksheet Functions | |||
make a macro to move specific rows to another sheet | Excel Worksheet Functions |