Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to exclude the last 3 worksheets from the following macro. Can you
please show how the code should be adjusted (and cleaned up). Many thanks. Sub Sheetsless3() Dim wSht As Worksheet Dim myRng As Range Dim allwShts As Sheets Set allwShts = Worksheets For Each wSht In allwShts wSht.Columns(1).ColumnWidth = 51.57 wSht.Columns(2).ColumnWidth = 8 Set myRng = wSht.Range("C4:N4") With myRng .HorizontalAlignment = xlRight .VerticalAlignment = xlTop End With Next wSht End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print macro to exclude a cell | Excel Discussion (Misc queries) | |||
Printing Selected worksheets but exclude the sheet "Sheets" | Excel Discussion (Misc queries) | |||
Edit code - exclude sheets | Excel Programming | |||
Sort Macro to Exclude Blank Rows? | Excel Worksheet Functions | |||
Graphics Call With Macro - How to Exclude Some Pix? | Excel Programming |