Excel のこととか楽天とか いろいろ書いてみます・・・


【Excel/VBA】AutoFilter, Filtering For Blanks or Not Blanks

This macro filter for blanks or non-blanks by one click. I take "Split" function just I learned and array for this macro. You will see how to get the range of the AutoFilter, and this made my macro works on any Excel books