Visual Basic Macro

G

Guest

Why is this programing not working? it gets stuck selecting the cells to
paste. The reason I am copying and pasteing then coping and pasteing values
it because I am pasteing into a sheet with merged cells.

Sheets("Daily").Select
Range("A9:p63").Select
Selection.Copy
Sheets("email").Select
Range("A9:p63").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
 
K

KL

Hi negzel,

Have you considered the following?

Sheets("email").Range("A9:p63").Value = _
Sheets("Daily").Range("A9:p63").Value

Regards,
KL
(XL 97, 2000, 2002)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time error 1004 paste method of worksheet class failed 3
Macro to run on hidden sheet 4
Copy & paste macro for multiple worksheets 8
How to macro to relative position 6
End Down a second time 1
Looping Macro 5
macro or formula to paste values from one tab to another 1
Run macro from active workbook whose name keeps changing 20

Top