Thread: Macro to copy contents in current row to Sheet2
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
theDude[_2_] theDude[_2_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote