Apply Macro to Filtered List

**YOO629** · 06-03-2015, 02:24 PM

Hello all,

Currently I have two macros where two columns are of importance: one column has names, the other has numbers (both columns have text headers).

The code for the first macro is this:

Please Login or Register  to view this content.

So this one works the way I want it to (I had to edit the real names before posting here). It filters my list by the names that I've given it. After it filters my list, I manually select the second column with numbers and use my second macro.

The second macro is this:

Please Login or Register  to view this content.

The problem is that the second macro seems to be applied to ALL cells in the range from the first cell I selected to the last cell I selected (including all cells that were supposed to have been filtered out), and not just the ones that I've selected/filtered for. Any ideas?

**Leith Ross** · 06-03-2015, 02:48 PM

Hello YOO629,

In VBA 99 percent of the time you will never have to use Select or Activate in your code. To help you get the code working, you should post a copy of your workbook.

Please redact or change any personal, sensitive, or confidential information before you post the workbook.

**YOO629** · 06-03-2015, 05:10 PM

Thanks for the reply Leith. I took your advice and changed the selection.autofilter to cells.autofilter

Fortunately, I managed to find a solution to my problem online.

I'll share it here for everyone else:

Please Login or Register  to view this content.

This code will go through a filtered list in column A starting from cell A2 and down and divide each cell value by 2. note that in my case, all entries in column A are numbers except for cell A1, which is a column header.