PC Review


Reply
Thread Tools Rate Thread

copy active row and repaste values

 
 
J.W. Aldridge
Guest
Posts: n/a
 
      1st Mar 2010
keep getting runtime error....

want to copy active row and repaste values only.


Sub Macro3()

ActiveCell.Offset(Rowcount).EntireRow.Copy

Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False

End Sub
 
Reply With Quote
 
 
 
 
JLGWhiz
Guest
Posts: n/a
 
      1st Mar 2010
Sub Macro3()

ActiveCell.EntireRow.Copy

Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False

End Sub



"J.W. Aldridge" <(E-Mail Removed)> wrote in message
news:db5fedf6-d7b6-45c1-b663-(E-Mail Removed)...
> keep getting runtime error....
>
> want to copy active row and repaste values only.
>
>
> Sub Macro3()
>
> ActiveCell.Offset(Rowcount).EntireRow.Copy
>
> Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
> SkipBlanks:= _
> False, Transpose:=False
>
> End Sub



 
Reply With Quote
 
J.W. Aldridge
Guest
Posts: n/a
 
      1st Mar 2010
THANX ALL!
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel2007: copying filtered table values, how can I copy ONLY thefiltered values AC Microsoft Excel Discussion 2 27th Nov 2009 09:27 PM
copy unique values into listbox, then modify sheet from these values Matthew Dyer Microsoft Excel Programming 4 28th Sep 2009 04:11 PM
Find matching values, copy/paste values as well as values in ColA ryguy7272 Microsoft Excel Programming 2 28th Sep 2009 06:20 AM
Copy active sheet to new - do no copy buttons =?Utf-8?B?Q2FybGVl?= Microsoft Excel Programming 3 13th Jun 2007 04:33 PM
Save copy of active sheet - values and formats only Lance Fairway Microsoft Excel Discussion 1 18th Aug 2006 03:03 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:06 AM.