Horje
excel vba copy range with filter Code Example
excel vba copy range with filter 
Sub ExtractVisibleCells()

    Dim wsSource, wsExtract As Worksheet

    Set wsSource = ThisWorkbook.Sheets("Source Data")
    Set wsExtract = ThisWorkbook.Sheets("Filtered")

    wsSource.Range("A1:A10").SpecialCells(xlCellTypeVisible).Copy
    wsExtract.Cells(1, 1).PasteSpecial

End Sub



3

Related
shortcut to apply a formula to an entire column in excel Code Example shortcut to apply a formula to an entire column in excel Code Example
xlvba check for folder Code Example xlvba check for folder Code Example
excelvba check for directory Code Example excelvba check for directory Code Example
random number generator vb.net Code Example random number generator vb.net Code Example
vba loop through files in folder Code Example vba loop through files in folder Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 9



 

Horje