| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Easier Way to do it?
Is there an easier or more logical way to write this code?
Sheets("Form Data").Range("C3").Copy Sheets("New Deal Data").Range("AA5").PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Easier Way to do it?
Sheets("Form Data").Range("C3").Copy _
Sheets("New Deal Data").Range("AA5") -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Kurt Barr" wrote in message ... Is there an easier or more logical way to write this code? Sheets("Form Data").Range("C3").Copy Sheets("New Deal Data").Range("AA5").PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Easier Way to do it?
Hi Kurt Barr
If you are going to keep Paste:=xlPasteFormulas Sheets("Form Data").Range("C3").Copy Sheets("New Deal Data").Range("AA5").PasteSpecial Paste:=xlPasteFormulas if it`s only value then Sheets("New Deal Data").Range("AA5") = _ Sheets("Form Data").Range("C3").value Regards Yngve |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Easier Way to do it?
Thank you very much.
"Yngve" wrote: Hi Kurt Barr If you are going to keep Paste:=xlPasteFormulas Sheets("Form Data").Range("C3").Copy Sheets("New Deal Data").Range("AA5").PasteSpecial Paste:=xlPasteFormulas if it`s only value then Sheets("New Deal Data").Range("AA5") = _ Sheets("Form Data").Range("C3").value Regards Yngve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| An easier way? | Excel Discussion (Misc queries) | |||
| Is there an easier way? | Excel Worksheet Functions | |||
| Is there an easier way? | Setting up and Configuration of Excel | |||
| got to be an easier way? | Excel Discussion (Misc queries) | |||
| Is there an easier way? | Excel Discussion (Misc queries) | |||
Hybrid Mode
