copy part of row

[hme]

Hi everybody

I use:

rng.EntireRow.copy Destination:_
CurrentWkbk.Worksheets("sheet1").cells(Rows.Count, 1).End(xlUp)(2)

to copy entire row.

How can I copy just form column A to N.

Regards
HM

 

[sujata_ghosh]

hi!

try this to copy specific range of cell

Range("A9:N9").Select
Selection.Copy
Application.CutCopyMode = Fals

 

[sujata_ghosh]

hi!

try this to copy specific range of cell

Range("A9:N9").Select
Selection.Copy
Application.CutCopyMode = False


sujat

 

[Tom Ogilvy]

set rng1 = rng.parent.Cells(rng.row,1).Resize(1,14)
rng1.EntireRow.copy Destination:_
CurrentWkbk.Worksheets("sheet1").cells(Rows.Count, 1).End(xlUp)(2)