| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA .copy destination
I have this code: Worksheets("Sheet1").Range("A1:D4").Copy _ destination:=Worksheets("Sheet2").Range("E5") doing it this way copies the formatting as well, is there a way to copy just the value over without the cell format? Thanks in advance -- jerredjohnson ------------------------------------------------------------------------ jerredjohnson's Profile: http://www.excelforum.com/member.php...o&userid=32236 View this thread: http://www.excelforum.com/showthread...hreadid=562642 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to set a default paste option of "Match Destination Format" | Excel Discussion (Misc queries) | |||
| sort source workbook data, maintain formulas in destination workb. | Excel Worksheet Functions | |||
| How do I autofill combo boxes with their destination cell? | Excel Worksheet Functions | |||
| XL2003 Destination and Source Open but not updating | Excel Discussion (Misc queries) | |||
| Hyperlinks - identifying source in destination sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
