VBA中简单实用的语句（国外英文资料）.docVIP

VBA中简单实用的语句（国外英文资料） Common statements (1). Workbook 1. On the Error Resume Next ignore the Error to continue VBA code, avoid the Error message On Error GoTo ErrorHandler jump to somewhere in the process when the Error occurs Application. DisplayAlerts = False will not be displayed during the execution of the program Application. Screenupdate = False closes the screen refresh Application. Screenupdate = True opens the screen refresh The activeworkbook.name returns the name of the activity job 6 ActiveWorkbook. WindowState = xlMaximized maximizes the current workbook (Sheet1).name = Sum The Work