help with vba code please

[Die_Another_Day]

This one was close:
..Range("A" & cnt:"I" & cnt).Copy Sheets("sheet1").Range("A" & nRow)
Modified to this:
..Range("A" & cnt & ":I" & cnt).Copy Sheets("sheet1").Range("A" & nRow)

Charles

 

[Guest]

You must die laughing at what us morons attempt to do. THANKS MUCH!!

David