By the way, this recorded macro works, but I don't want to use it. I'm trying not to do this much hardcoding of values. That's why my procedure is try...
P.S. - If prompted, the password is my last name.
Ugh. I always miss that error about file size. I deleted all the irrelevant forms, etc. and zipped the file. Now it's small enough and attached. Thank...
Thank you, Velouria. I made that update. I'm attaching a sample XLS which illustrates that I'm still struggling with slicer caches and slicers, des...
With respect to the GoTo statements... this is what I ended up with (just in case anyone out there in Internetland finds it useful). Notice a "gotcha"...
My apologies. I confused two questions I had about the same sample workbook. The code I pasted in my last comment above works to limit the slicer t...
P.S. - It occurs to me that the simplest solution, albeit the most fragile in case of structural changes to the worksheet, might just be: If A...
Thanks, Velouria. The following code works, but it seems unnecessarily complicated. Thoughts? CODE IN WORKSHEET Private Sub Worksheet_Pivo...
Thanks. I understand the issue now, but I'm not sure why my update is causing run-time error 91: "Object variable or With block variable not set" T...
Thank you. I ended up with the following, and it works like a charm... *** CODE IN A MODULE *** Sub SaveFormTopLeft(ByVal FormName As String, By...
Thank you for your suggestion I'm sorry, but I am still struggling to make this work. Please see the updated XLS attached. In your example, "Cubs"...