Fill Series when filter is on with a Macro

Hello,

I am trying to create a macro that does a few fiunctions and filters with autofilters. I am at the point where I have a filtered list. I need to change all the values for a column of the filtered list from Open to Closed.

I want to have the macro complete this but am having a hard time figuring out how it would find the first row that appears in the filtered list since it will be variable.

It would be as if I selected the first visible row, changed the value to Closed and double clicked the bottom right of the cell to fill all the cells below.

I have attached an example. The first tab is the basic table, the second tab showns the filtered data that I would type Closed in the first cell and double click the bottom right. The third is the desired results.

Thank You for your help,

Stephen

Hi

Run the following

Please Login or Register  to view this content.

on your filtered sheet. In your example file that is the when it is at the Filter on Column B stage.

rylo