Something very strange is going on.
I have a spreadsheet saved with an autofilter on.
I then call one method (via a button) which fills some data and does some filtering.
I then change one of the filtered (visible) cells from N to Y.
However, when I call the next method (via a second button) I get error 91 when trying to address the range
i.e.
givesCode:Private Sub cmdDownload_Click() Dim rngFilter As Range Set rngFilter = Sheet14.AutoFilter.Range
Also checking AutoFilterMode returns falseCode:Object variable or With block variable not set
This then has the effect of REMOVING the autofilter that was previously on. (Because it thinks it is off when it isn't "Sheet14.Range("B11").AutoFilter" has the effect of turning it off instead of on)Code:Private Sub cmdDownload_Click() If AutoFilterMode = False Then Sheet14.Range("B11").AutoFilter End If Dim rngFilter As Range Set rngFilter = Sheet14.AutoFilter.Range
If I put 2 such blocks, I end up with the AutoFilter displayed on screen.
However, I still get the error when I try to set my range.![]()




Reply With Quote