Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
On Error Resume Next problem
In my code after my DIM statements I have:
On Error GoTo wsAdd With Sheets("MySummary") .Activate .Cells.ClearContents End With Let's say MySummary (sheet) does not exist - so macro jumps to: wsAdd: Sheets.Add after:=Sheets(Sheets.Count) ActiveSheet.Name = "MySummary" On Error GoTo 0 Resume Next '<< Creates and Names Sheet MySummary an returns to the line: .Activate << Where the Macro Bombs -- What is wrong?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Theatrical Resume | New Users to Excel | |||
On Error Resume Next (when next statement is Do Loop ...) | Excel Discussion (Misc queries) | |||
resume.xlw | Excel Discussion (Misc queries) | |||
On error resume next problem | Excel Discussion (Misc queries) | |||
can I create a new resume? | Excel Discussion (Misc queries) |