I'm slowly learning how to use VBA and could use a bit of help understanding this: How do I create a dynamic range that depends on the number of columns in the sheet? For instance, I wanted to add an Auto Filter to my report that has 5 columns, so I wrote

Range ("A1:E1").AutoFilter

Since this particular report might have 6, 7, 8, 9, 10+ columns, I need to write the code so that it can count the columns and automatically create the correct range.

If you have the time, could you walk me through the steps for doing this?