I had saved the sheet as a Excel macro enabled workbook after creating a module for "counting Coloured cells". However on applying filters the message kept popping up"cannot shift objects off sheet[/U][/B]". I removed the module and save the sheet as normal Excel workbook , but the filters fail to apply with the same pop up message.
If possible share the code with the sample file
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks