access vba course - Error checking

Resolved · Low Priority · Version Standard

Thu 12 Jul 2007, 10:02 Delegate John said...

John has attended:
Excel VBA Intro Intermediate course

Error checking

What are the three ways of error checking?

Tue 17 Jul 2007, 16:00 Trainer Carlos said...

RE: Error checking

Hi John

The three ways of error cheching are:

On Error Resume Next - Go to the next line of code

ON Error Exit Sub - Exit the routine where this line is

On Error Go To EH - Go to an error routine at the end of the routine where the error checking is taking place

Regards

Carlos

VBA tip:

Add A New Sheet at the end of the Workbook

To add a new sheet at the end of the workbook you need to count the sheets in the workbook using:

Sheets.Count

Then use this value as the rank of the sheet after which you want to add the new sheet:

Sheets.Add After:=Sheets(Sheets.Count)

View all VBA hints and tips

access vba course - Error checking

Error checking

RE: Error checking

VBA articles

VBA tip:

Add A New Sheet at the end of the Workbook