Thank you. As clever as it is simple. It works perfectly. Two follow-up questions: QUESTION 1 I currently check whether the user form option ...
That worked perfectly. Sub FilterTheNewSlicer() ' Declare variables for this procedure Dim slcrC As SlicerCache Dim slcr As Slicer ' Lo...
I've uploaded the XLS. I had to ZIP it to get it small enough. I also removed several user forms, sheets, and modules not relevant to this problem. An...
Well, that's an interesting point. Thanks!
Thank you, Velouria. Everything is working now!
Thanks, as always. I'll continue to investigate, but... The message box toward the top of the SliceByIndex sub displays this message: "The name of ...
Thank you. Your help got everything working. Much appreciated.
Hmmm. Gotta say, that's certainly more elegant than what I had written. I'm still not understanding, because my code throws an error. I've read some o...
Thank you, as always.
YES... The error is "Object doesn't support this property or method." That error occurs on both the ".CrossFilterType = SlicerFormat.CrossFilterType" ...