I am getting a Run-time error '1004' (Clear method or Range class failed).
When i use the following code before i load or show the userform, it works fine but when i am trying to use the code during the Combobox change event I get the above error.
I am trying to clear one of the sheets
Code:
HTML Code:'Clear Filter With shFilter .Cells.Clear .AutoFilterMode = False End With
Thanks for any help,
JJ
Maybe we could see that in the context of a workbook with a form in it?
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks