| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Switch between two states
Hi all,
The blank ranges on a worksheet should be hidden out before the worksheet is printed. It is easy to do it, but after printing, the worksheet shoul restore to its original state before printed. Is there an easy way to do it in Excel? Clara -- thank you so much for your help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Switch between two states
Hi
If rows and columns have been hidden try Sub tester() ActiveSheet.Columns.Hidden = False ActiveSheet.Rows.Hidden = False End Sub regrads Paul On May 3, 5:21 pm, clara wrote: Hi all, The blank ranges on a worksheet should be hidden out before the worksheet is printed. It is easy to do it, but after printing, the worksheet shoul restore to its original state before printed. Is there an easy way to do it in Excel? Clara -- thank you so much for your help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display Excel 2007 data by states using United States (US) map | Excel Discussion (Misc queries) | |||
| Percentile for specific states | Excel Worksheet Functions | |||
| How can I create a U.S. map where I can mark certain states? | Charts and Charting in Excel | |||
| US states | Excel Worksheet Functions | |||
| How to find top five States? | Excel Worksheet Functions | |||
Hybrid Mode
