| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to copy contents in current row to Sheet2
Hi Mike, Sorry for the delay...I've been unavailable for a while. This should work for you: Code: -------------------- ActiveCell.EntireRow.Copy Sheets("RMA Details").Activate Rows("34:34").Select ActiveSheet.Paste Application.CutCopyMode = False ActiveSheet.Range("B34").Select -------------------- Hope this helps, theDude -- theDude ------------------------------------------------------------------------ theDude's Profile: http://www.excelforum.com/member.php...o&userid=16550 View this thread: http://www.excelforum.com/showthread...hreadid=372633 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to copy contents in current row to Sheet2
a bit shorter without selections
Sub copyrow() Rows(ActiveCell.Row).Copy Sheets("sheet12").Range("a14") End Sub -- Don Guillett SalesAid Software "theDude" wrote in message ... Hi Mike, Sorry for the delay...I've been unavailable for a while. This should work for you: Code: -------------------- ActiveCell.EntireRow.Copy Sheets("RMA Details").Activate Rows("34:34").Select ActiveSheet.Paste Application.CutCopyMode = False ActiveSheet.Range("B34").Select -------------------- Hope this helps, theDude -- theDude ------------------------------------------------------------------------ theDude's Profile: http://www.excelforum.com/member.php...o&userid=16550 View this thread: http://www.excelforum.com/showthread...hreadid=372633 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
| macro to print sheet2 without open sheet2 | Excel Discussion (Misc queries) | |||
| Macro to Copy data from a list in sheet1 and paste into sheet2 | Excel Discussion (Misc queries) | |||
| how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ | Excel Discussion (Misc queries) | |||
| search Sheet2! for the contents of Sheet1! | Excel Discussion (Misc queries) | |||
![theDude[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
