| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
why does this macro select the entire worksheet when run?
Here's the macro:
Sub UnhideAll() 'Unhides all rows 'Freezes window at E4 Cells.Select Range("B1").Activate Selection.EntireRow.Hidden = False Selection.EntireColumn.Hidden = False Range("E4").Activate ActiveWindow.FreezePanes = False ActiveWindow.FreezePanes = True End Sub Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need a macro select all cells in a worksheet? | Excel Discussion (Misc queries) | |||
| Want macro to select & copy cells from a different worksheet | Excel Discussion (Misc queries) | |||
| Macro that double spaces rows for an entire worksheet? | Excel Discussion (Misc queries) | |||
| Macro to print a selected range, not entire worksheet | Excel Discussion (Misc queries) | |||
| select worksheet to run macro | Excel Discussion (Misc queries) | |||
Threaded Mode
