Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Visual Basic Macro
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 |
#2
|
|||
|
|||
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) "negzel" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula in Visual Basic For Excel | Excel Discussion (Misc queries) | |||
Visual Basic System Error-Userform | Excel Discussion (Misc queries) | |||
Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) | |||
Visual Basic Help | Excel Discussion (Misc queries) |