Turn off 'Show items deleted from the data source' in sliders by default. Stupid setting!
Turn off Autoifit column widths on update in pivots. Stupid setting!
Turn off 'Show items deleted from the data source' in sliders by default. Stupid setting!
I would like to see a change to AutoFilter. I would like to see the choices "(Select All)" and "(Blanks)" either
a) Fixed, readily accessible, in the top section like "Text Filters", "Filter by Color" etc, or
b) (2nd choice) Listed at both the top and bottom of the scroll section.
I hate scrolling all the way to the bottom to take the tick off blanks, only to find there are no blanks.
Similarly, if I'm at or near the bottom of the scroll section and decide I want to show all, I'd like to be able to do so without a lot of scrolling first.
A native MAXIF(s) woudl be handy as well
But then who woudl ask this question anymore...
Sub test()
Dim c As Range
Set c = Range("C:C").FindAll("findthis")
c.Copy Range("E:E")
End Sub
I'm agreeing with you too, just like I did with Rick earlier..FindAll in VBA ...