I am a new to most of this but have done ok with google so far. I have a problem doing a copy and paste , trying to paste into the first blank row of a workbook. Here is what I am trying to use right now

..Columns("A:F").AutoFilter Field:=6, Criteria1:="Brand
..Columns("A:F").SpecialCells(xlCellTypeVisible).C opy Destination:=
Windows("AllBrands").ActivateSheets("Sheet1").Rang e("A" & Rows.Count).End(xlUp).Offset(1

I get this error message - and I am not sure what it mean
"Object Doesn't Support This Property Or Method

It is pasting from one workbook to another - in case that is importan

I would appreciate any advise I can get on this - I am really not sure what is wrong