| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Unhide Rows
Need help with an excel 2003 macro to simply unhide a certain number of rows
in a spreadsheet (# of rows to be unhidden is based on user input). Here's what I have & it's not working... With Sheets("Inputs").Select X = Range("U2") Y = Range("X2") Rows("X:Y", 0).Select Range("Y").Activate Selection.EntireRow.Hidden = False End With U2 is a fixed entry, the row # in X2 is calculated based on a user input (# of additional rows required). Thanks, Robert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to Unhide Rows using Macro | Excel Worksheet Functions | |||
| Can you hide and unhide rows with a macro based on content of colu | Excel Programming | |||
| unhide row does not unhide the hidden rows | Excel Worksheet Functions | |||
| Macro that will unhide then hide rows | Excel Discussion (Misc queries) | |||
| How do I hide or unhide zero value columns/rows USING A MACRO? | Excel Discussion (Misc queries) | |||
Threaded Mode
