Forum Discussion
Filldown VBA not working
Hello, I have some coding which filters some columns to find data I need to add a comment against, then writes the comment and fills it down to the bottom. However, the Filldown isn't working. Everyt...
The instruction
Range("AB1:AB" & lastRow).Offset(1, 0).SpecialCells(xlCellTypeVisible).Areas(1).Rows(1).Select
selects a single cell. So there is nothing to fill down.
- What would I need to replace this with in order to make it fill down?
Please explain what you want to do - it's difficult to follow the code.
- So I want it to Enter "Completed" in the top cell (which it does) and then copy that down to the bottom, so all of those blanks filled with "Completed"
