VBA to actvate Unfilter after Auto Filter

Hi All,

I have pieced together the below code to autofilter a workbook based on the cell entry in Sheet 1, A1. The code works great whilst sorting the information, but has a run time error when entry is " ", this entry should unsort all infomation in the previously sorted sheets.
I would also like the first two sheets excluded from the sort and the code to run on the cell change.

Please Login or Register  to view this content.

Any help is much appreciated

Cheers

Adam

Try this (untested)

Please Login or Register  to view this content.

Try this in the worksheet 1 code module (not in a separate module)

Please Login or Register  to view this content.

Kieran,

Please use code tags when posting as per forum rules below. I've done it for you this time

VBA Noob