' Author : Daniel Pineault, CARDA Consultants Inc.
"Error Source: "ResetAutoFilter ", vbCritical, "An Error Has Occurred " It may not be sold/resold or reposted on other sites (links ' back to this site are allowed). ' Website : ' Purpose : Reset the AutoFilter in the specified worksheet of the active workbook ' Copyright : The following may be altered and reused as you wish so long as the ' copyright notice is left unchanged (including Author, Website and ' Copyright).
'- ' Procedure : ResetAutoFilter ' Author : Daniel Pineault, CARDA Consultants Inc. Similarily, if you wanted to reset the AutoFilter in one specific worksheet to display all the data, you could use a procedure such as: "Error Source: " & "ResetAutoFilters", vbCritical, "An Error Has Occurred" It may not be sold/resold or reposted on other sites (links ' copyright notice is left unchanged (including Author, Website and ' Copyright : The following may be altered and reused as you wish so long as the ' Purpose : Resets all the AutoFilter in all the worksheets of the current workbook "Error Source: " & "ResetAutoFilters", vbCritical, "An Error Has Occurred" Resume Exit_Error_Handler "Error Description: " & Err.Description & vbCrLf & _ MsgBox "Error Number: " & Err.Number & vbCrLf & _ ' Website : ' Purpose : Resets all the AutoFilter in all the worksheets of the current workbook ' Copyright : The following may be altered and reused as you wish so long as the ' copyright notice is left unchanged (including Author, Website and ' Copyright). '- ' Procedure : ResetAutoFilters ' Author : CARDA Consultants Inc.