Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Good Afternoon All,
I have a macro that excludes a certain page from the Clear code I'm using below. I now have a second page named "Front Page 2" that I am also looking to exclude from this function. After several feeble attempts to modify and add "Front Page 2" to this code, I've been unsuccessful and was wondering if someone had an idea that would enable this request. Thanks so much in advance - Jenny B. Sub Clear() For Each Ws In Worksheets If Ws.Name < "Front Page" Then Application.ScreenUpdating = False Ws.Activate Dim RangeClear As Range Set RangeClear = Range("a:IV") RangeClear.ClearContents Range("A1").Select ActiveCell.FormulaR1C1 = "0" Sheets("Front Page").Select End If Next Application.ScreenUpdating = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Omit header from first page without embedding header in code | Excel Worksheet Functions | |||
Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
Unprotect Code Module in Code | Excel Discussion (Misc queries) | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) | |||
Viewing source code when saved as web page | Excel Discussion (Misc queries) |