Record yourself a macro of you adding the shape and making modifications to it. Make sure you store it in the Personal Macro Workbook, you can alter the...
p45cal Today, 01:01 AMTry the button in the attached which runs this code:
Sub blah() lr = Cells(Rows.Count, "A").End(xlUp).Row For rw = lr To 3 Step -1
I cannot see any difference. You are the one asking for help: all I have asked is that you provide a version with a few specific anomalies highlighted...
AliGW Yesterday, 04:15 PMJust pick any one row in my 50 entries/page and compare to your attached file (same row) and you see they are not the same. This only happens in my 50...
guanstan Yesterday, 03:29 PM
Private sub to refresh pivotfields
Is there a way to combine private sub with refreshing pivot fields?
thousand Today, 05:29 AMWant to keep PivotFields("ABC") to always be selected as "True"....