Enable and Disable of Excel Error Message SimonFeiXiang 5:04 PM No comments These alerts can be turned off by using this VBA-code: Application.DisplayAlerts = False After a routine you must turn on alert messages: Application.DisplayAlerts = True Share This: Facebook Twitter Google+ Stumble Digg
Delete entire empty rolls SimonFeiXiang 12:02 AM No comments Function delRolls () On Error Resume Next worksheet.Columns("A:A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete On Error GoTo 0 End Function Share This: Facebook Twitter Google+ Stumble Digg