I am currently working on a Macro that deals with a a set of filtered rows. The user needs to be able to create any number of rows for this macro to apply to, and there are some hidden rows due to the filter so I don't believe I can tell excel to select the next 100 rows to apply the macro to, as that would apply to the hidden cells.
The first part of the Macro goes like this:
ActiveSheet.Range("$A$1:$AW$377").AutoFilter Field:=18, Criteria1:="=" ActiveSheet.Range("$A$1:$AW$377").AutoFilter Field:=19, Criteria1:="<>" Range("AB2").Select Selection.FormulaR1C1 = "=IF(RC[-11]=""Monday"",RC[-12],""DELETE"")" Range("AB2").Select Selection.FillDown That filldown command works perfectly whe I record the macro, but when it runs, instead of copying that cell down into all applicable cells below, it copys the header cell above it into the destination cell.
Is there another command I can use to get this running properly?
4Related questions 0 vb copy line with pull down selection 0 Copy cell value to all cells below it 0 copying and pasting into another cell Related questions 0 vb copy line with pull down selection 0 Copy cell value to all cells below it 0 copying and pasting into another cell 0 VBA code to select specific cell and paste down accordingly 0 How to copy cell value and paste under previous cell 0 Trying to select a range of cells from one column and paste it below the last filled cell in another column 0 VBA excel copy above cells when intersect 0 VBA to copy a specific cell and paste into adjacent column 0 how to select specific cell to next one after the cell filled 0 FillDown Method Load 7 more related questions Show fewer related questions
Reset to default
