copy part of row
 

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

--
hm
-----------------------------------------------------------------------
hme's Profile: http://www.excelforum.com/member.php...fo&userid=1593
View this thread: http://www.excelforum.com/showthread.php?threadid=27796

copy part of row
 

hi!

try this to copy specific range of cell

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

--
sujata_ghos
-----------------------------------------------------------------------
sujata_ghosh's Profile: http://www.excelforum.com/member.php...fo&userid=1643
View this thread: http://www.excelforum.com/showthread.php?threadid=27796

copy part of row
 

hi!

try this to copy specific range of cell

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


sujat

--
sujata_ghos
-----------------------------------------------------------------------
sujata_ghosh's Profile: http://www.excelforum.com/member.php...fo&userid=1643
View this thread: http://www.excelforum.com/showthread.php?threadid=27796

copy part of row
 

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)


--
Regards,
Tom Ogilvy


"hme" wrote in message
...

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
HME


--
hme
------------------------------------------------------------------------
hme's Profile:
http://www.excelforum.com/member.php...o&userid=15930
View this thread: http://www.excelforum.com/showthread...hreadid=277967