| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy part of VLOOKUP formula? | Excel Discussion (Misc queries) | |||
| copy part of large WS to another sheet | Excel Worksheet Functions | |||
| Find and copy part of a cell | Excel Worksheet Functions | |||
| How do I copy part of each cell in a column? | Excel Discussion (Misc queries) | |||
| Copy and Paste part II | Excel Programming | |||
Hybrid Mode
