Option Explicit

Sub do_paste()

Dim myRange As Range
Dim myOtherRange As Range

Set myRange = Worksheets("Sheet1").Range("A1:B1")
Set myOtherRange = Worksheets("Sheet2").Range("A3:B3")

myRange.Copy
myOtherRange.PasteSpecial xlPasteAll

Application.CutCopyMode = False

End Sub

this is the whole code. i have trouble getting "paste" to work so
find .PasteSpecial xlPasteAll does the same thing.
:)
susan

On May 1, 12:08*pm, Susan wrote:
myRange = Worksheets("Sheet1").Range("A1:B1")
myOtherRange = Worksheets("Sheet1").Range("A3:B3")

myRange.Copy
myOtherRange.Paste

hope this helps........ i have no idea what you're doing with the
other code........ :)
susan

On May 1, 11:36*am, staciedaisy



wrote:
pretty much i am needing to know how to paste the clipboard as a macro

"staciedaisy" wrote:

I am getting an error message
<snip

thanks in return!!!!!!!!!!!!!!!!- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -