Copying visual cells into a new workbook

Question

In theory I can just use the specialcells method to copy visual cells after filtering into a new sheet, but I am getting an error:

MasterList.Range("$A$1:$AK$" & RowCountTotal).SpecialCells(xlCellTypeVisible).Copy TemporaryWorksheet.Cells("A1")

How would I copy these visual cells in the masterlist into the temporary worksheet?

With the changes that Tim suggested, I am getting Run Time Error 1004, Select Method of Range class failed — orange123, Mar 16 '21 at 16:12
[You should avoid Select](https://stackoverflow.com/questions/10714251/how-to-avoid-using-select-in-excel-vba) but there's no way to help you further as it seems another line is throwing that error. — BigBen, Mar 16 '21 at 16:54

score 0 · Answer 1 · answered Mar 16 '21 at 16:05

0

Cells("A1")

should be

Range("A1")

or

Cells(1, "A")

answered Mar 16 '21 at 16:05

Tim Williams

1 Answers1