My current macro includes this line:
Range("A2:A" & LastRow).SpecialCells(xlCellTypeVisible).EntireRow.Copy
For each row selected, it copies the entire row. I need to change this line so that it copies only A through R in that row. So I need to replace "EntireRow" to what? Or some other change?
The entire macro is below, thanks!
Please Login or Register to view this content.
Bookmarks