Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code to Fill Down in a filtered list only to visible cells.
VBA code to Fill Down in a filtered list only to visible cells.
I am trying to create a macro that will fill down in a column based on a filtered column in a list. I'm creating a formula in a separate column which I want to fill down to only the visible cells based on the filtered field. i.e. I am filtering on Column C to show only values 'X'. Then in Column D, I want a formula I create in the first record to be duplicated to all of the visible cells/rows in that column to the bottom of the list. Any ideas? Thanks in advance! Training Goddess |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code to Fill Down in a filtered list only to visible cells.
"Goddess" i'm in lurve ;)
Sub Demo() Dim cell As Range Dim source As Range Set source = Range("C2:C500") For Each cell In source.SpecialCells(xlCellTypeVisible) If cell < "" Then cell.Offset(, 1).FormulaR1C1 = Range("D2").FormulaR1C1 End If Next End Sub "Training Goddess" wrote: VBA code to Fill Down in a filtered list only to visible cells. I am trying to create a macro that will fill down in a column based on a filtered column in a list. I'm creating a formula in a separate column which I want to fill down to only the visible cells based on the filtered field. i.e. I am filtering on Column C to show only values 'X'. Then in Column D, I want a formula I create in the first record to be duplicated to all of the visible cells/rows in that column to the bottom of the list. Any ideas? Thanks in advance! Training Goddess |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA code to Fill Down in a filtered list only to visible cells. | Excel Programming | |||
VBA code to Fill Down in a filtered list only to visible cells. | Excel Programming | |||
VBA code to Fill Down in a filtered list only to visible cells. | Excel Programming | |||
How do I only delete/clear the visible cells in a filtered list? | Excel Worksheet Functions | |||
Code ignoring filtered (visible) tasks. | Excel Programming |