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. |
#2
|
|||
|
|||
you have some references to unqualified ranges (cells(1,1) and cells(5,1) refer
to the activesheet. You could use something like: with sheets("abc").range("xyz") .range(.cells(1,1),.cells(5,1)).entirerow.hidden = false end with Those dots mean that the range belongs to the previous With object. Ben wrote: 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. -- Dave Peterson |
#3
|
|||
|
|||
Thank you Dave.
I added the "." and now it is working fine. Thank you again. "Dave Peterson" wrote: you have some references to unqualified ranges (cells(1,1) and cells(5,1) refer to the activesheet. You could use something like: with sheets("abc").range("xyz") .range(.cells(1,1),.cells(5,1)).entirerow.hidden = false end with Those dots mean that the range belongs to the previous With object. Ben wrote: 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. -- Dave Peterson |
Reply |
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 |