In a filtered column, I want move to next visible row, so I can copy that cell and paste to a cell outside the filtered list.
The headers for the filter are in row 3. The cell below C3 has info that I want to copy to cell A2, which is outside the filtered area. The code below moves the selected cell down 1 row (always to row 4) rather than to the next filtered row.
In the code below, what do I need in place of the activecell.offset command?
Please Login or Register to view this content.
Bookmarks