vba to Copy row!

[samahiji]

Hello

Can anyone figure out why the following code to copy row("10:10") showing an error?!!

    Sheets("TST").Rows(10).SpecialCells(xlCellTypeConstants, 23).Copy _
    Destination: MM.Range("A1").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=True, Transpose:=True

 

[Caleeco]

Hello,

You are missing the '=' on the destination argument

Try this instead. However, i donthink pastespecial works with the 1 line copy/paste method. Try this instead

Sub TestCopy()
 Sheets("TST").Rows(10).SpecialCells(xlCellTypeConstants, 23).Copy
 MM.Range("A1").PasteSpecial Paste:=xlPasteValues
End Sub

Caleeco

 

[samahiji]

WOOOW

it works finally

Thanks a lot Caleeco

I added the skipblanks and transpose code

 

[Caleeco]

WOOOW

it works finally

Thanks a lot Caleeco

I added the skipblanks and transpose code

No problem Samahiji, glad you got it working