Hi I need a little help with this macro I've been working on. Some of it is from ctrl key macros that I have recorded and a little help from the forum. I ultimately need to get this macro to work across all the sheets in the work book. But only one portion of it works across all the worksheets. And I've been getting the following error. This portion worked on it's own, but combined with all the macros together as one wont!
ActiveWorkbook.Worksheets.AutoFilter.Sort.SortFields.Clear – Runtime error 91 object variable or with block variable not set
Any help would be greatly appreciated
Thanx
MZING81
Bookmarks