vba code meaning of SpecialCells(2, 1)

[RAM1972]

Hello

Can some one assist in vba code what is the meaning of SpecialCells(2, 1)

 

[MARK858]

It means SpecialCells(xlCellTypeConstants, xlNumbers).

https://msdn.microsoft.com/en-us/library/bb178148(v=office.12).aspx

 

[RAM1972]

It means SpecialCells(xlCellTypeConstants, xlNumbers).

https://msdn.microsoft.com/en-us/library/bb178148(v=office.12).aspx

Thanks Mark

but how to do this with a criteria BRUT/KG as text

Actually copies all first columns with text but I need to extract whole rows with the word specific" BRUT/KG"

Sub test2()
    With Sheets("sample")
        Union(.Range("a1:a2"), .Columns(1).SpecialCells(2, 2)).EntireRow.Copy Sheets.Add.Cells(1)
    End With
End Sub

 

[MARK858]

Rather than ask an ambiguous question about specialcells and posting code (which actually uses different specialcells parameters) that doesn't do what you want, can you try actually explaining what you want the code to do (including ranges, sheet names etc.)

 

[Rick Rothstein]

Rather than ask an ambiguous question about specialcells and posting code (which actually uses different specialcells parameters) that doesn't do what you want, can you try actually explaining what you want the code to do (including ranges, sheet names etc.)

SpecialCells is the VBA code equivalent of pressing the F5 key followed by clicking the "Special..." button on the dialog box that appears. This has nothing to do about finding specific text. I agree with Mark... why don't you tell us exactly what you have and exactly what you want to do with it and then maybe we can help you achieve your goal.