| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding complete Rows using a procedure
I want to hide rows 5,6 and 7 in a worksheet, I recorded the following macro
but it hides all rows containing data from 5 downwards. Sub HideSetupRows() Rows("5:7").Select Range("B5").Activate Selection.EntireRow.Hidden = True Range("B8").Select End Sub I have no idea why this happens, could any one offer an expaination? Thanks in advance Mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding rows and columns in a procedure | Excel Programming | |||
| Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
| End Sub, End complete procedure | Excel Programming | |||
| Copying Row Heights, or Complete Rows | Excel Programming | |||
| How do I sort by complete rows in excell | Excel Worksheet Functions | |||
Threaded Mode
