Excel's AutoFilter is convenient, but when a long list of " " arrows appears across many columns, doesn't it sometimes become a bit difficult to tell where you should filter? This is especially true ...

So, I am writing an application in Excel2000 and VBA. I am using Autofilter to go through a bunch of raw data in a worksheet, filter it out, and copy it to a new sheet. For example, I have a sheet ...

An AutoFilter is set on an Excel sheet, but have you ever wanted to know exactly which cell range on the sheet (e.g., A1:G100) that filter is targeting using a macro? Before running a macro, I want to ...