I have the following two lines of code: On Error Resume Next myWorkbook.Sheets(“x”).Columns(“D:T”).AutoFit I’ve stepped into the macro and executed the line On Error ……

Hi, Below is a simple sub to get user selected range – this is an example from John Walkenbach’s book. What I can’t understand here is that why in this program, “On ……

Hi I wrote a Where_Used Maro that finds part numbers in Multilple tabs and puts the part number row onto a report tab. The issue is sometimes the part…

Code: Sub Sample() For i = 7 To [Count] On Error Resume Next Workbooks.Open (Cells(i, 1).Value) If Err.Number 0 Then Err.Clear End If On Error GoTo 0 ‘…

Error handling is an important part of every code & VBA On Error Statement is an easy way for handling unexpected errors in Excel Macros in a graceful manner…

I am using this bit of code provided–by Aaron Blood, was it–on these forums. I have used error handling successfully in the past, but this time I can’t get Excel to ……