Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help! What's wrong with this simple copy and paste
This copy and paste does not work with my userform,
however it directly copied out of a macro I did. Any help will be appreciated! Worksheets("Report").Range("D48").Select Selection.Copy Sheets("Inputs").Select Range("M16").Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help! What's wrong with this simple copy and paste
It worked for me with xl2000 when used as a Commandbutton
click event. However, I would suggest greatly simplifying it by not doing all that selecting. Also forget the copy and paste. Try this simple code instead: Sheets("Inputs").Range("M1") = Sheets("Report").Range("D1") -----Original Message----- This copy and paste does not work with my userform, however it directly copied out of a macro I did. Any help will be appreciated! Worksheets("Report").Range("D48").Select Selection.Copy Sheets("Inputs").Select Range("M16").Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help! What's wrong with this simple copy and paste
Further, if your range is not a single cell, you can use the copy method:
Sheets("Inputs").Range("M1:AZ41") .copy destination: ... "Greg Wilson" wrote in message ... It worked for me with xl2000 when used as a Commandbutton click event. However, I would suggest greatly simplifying it by not doing all that selecting. Also forget the copy and paste. Try this simple code instead: Sheets("Inputs").Range("M1") = Sheets("Report").Range("D1") -----Original Message----- This copy and paste does not work with my userform, however it directly copied out of a macro I did. Any help will be appreciated! Worksheets("Report").Range("D48").Select Selection.Copy Sheets("Inputs").Select Range("M16").Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help! What's wrong with this simple copy and paste
Tim,
OP said values so copy would copy formula if data was a formula -- Don Guillett SalesAid Software "Tim Coddington" wrote in message ... Further, if your range is not a single cell, you can use the copy method: Sheets("Inputs").Range("M1:AZ41") .copy destination: ... "Greg Wilson" wrote in message ... It worked for me with xl2000 when used as a Commandbutton click event. However, I would suggest greatly simplifying it by not doing all that selecting. Also forget the copy and paste. Try this simple code instead: Sheets("Inputs").Range("M1") = Sheets("Report").Range("D1") -----Original Message----- This copy and paste does not work with my userform, however it directly copied out of a macro I did. Any help will be appreciated! Worksheets("Report").Range("D48").Select Selection.Copy Sheets("Inputs").Select Range("M16").Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple Macro - I think... Copy - Paste on Click | Excel Discussion (Misc queries) | |||
Line copy - Not just a simple copy paste | Excel Worksheet Functions | |||
copy-paste started misbehaving (cell reference wrong) | Excel Discussion (Misc queries) | |||
How to write a simple copy-paste macro? | New Users to Excel |