Macro select filtered worksheet

[Galceran]

I have a database in Excel 2003 with 794 rows. A macro filters the worksheet correctly. I now want it to select the filtered output (129 rows) so it can be copied to another worksheet for further formatting. I cannot get the code to select columns A:C down to the last row.
Thanks

 

[Desu Nota from Columbus]

With the filter in place (so all you can see is what you wish to copy/paste):

Cells.SpecialCells(xlCellTypeVisible).Copy `Enter location you with to paste here!!

 

[Desu Nota from Columbus]

In case this might help, here is a macro I wrote and use that does a similar function (copies filter cells and pastes them to new location):

In this example I am on Sheet "All Assets" using the autofilter function to copy/paste filtered results to new worksheets.

With Sheets("All Assets").Cells
    .AutoFilter
    .AutoFilter Field:=1, Criteria1:="Line10"
    .SpecialCells(xlCellTypeVisible).Copy
    Sheets("Line10").Paste
    .AutoFilter Field:=1, Criteria1:="Flowline"
    .SpecialCells(xlCellTypeVisible).Copy
    Sheets("Flowline").Paste
    .AutoFilter Field:=1, Criteria1:="Lamination"
    .SpecialCells(xlCellTypeVisible).Copy
    Sheets("Lamination").Paste
    .AutoFilter Field:=1, Criteria1:="Grinding"
    .SpecialCells(xlCellTypeVisible).Copy
    Sheets("Grinding").Paste
    .AutoFilter Field:=1, Criteria1:="=*Line*"
    .SpecialCells(xlCellTypeVisible).Copy
    Sheets("All Production").Paste
    .AutoFilter
End With

I didn't see you specify you wanted only columns A and C...

Range("A:A,C:C").SpecialCells(xlCellTypeVisible).Copy `select destination for paste

 

[Galceran]

Excellent. I selected cols A:C (A through C).

Thank you