Hi All,
I want to copy records where records = "a" at Column B. What's wrong with this syntax?
If on its own (without the copy), it is ok,![]()
Sheets("Sheet1").Range("B7:B" & ActiveSheet.UsedRange.Rows.Count).SpecialCells(xlCellTypeVisible).Value = "a".Copy
Regards,![]()
Sheets("Sheet1").Range("B7:B" & ActiveSheet.UsedRange.Rows.Count).SpecialCells(xlCellTypeVisible).Value = "a"
Nironto
Bookmarks