Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change PasteSpecial
I'm bringing in data from various worksheets into one worksheet - with each
of the worksheets being copied into the last row. Problem : I'd like to change the existing script from PasteSpecial to paste so I do not loose the time format. Currently it is changing the data into a value (ie 12:00 AM = ..05060) Have tried various wordings - pastevalue / value - but am not successful. thanks Windows("Extract data.xls").Activate With Sheets("Interval") lastrow = .Cells(.Rows.Count, "j").End(xlUp).Row Application.Windows(2).Activate Range("A1:J200").Copy .Cells(lastrow + 1, "j").PasteSpecial Paste:=xlAll End With |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change PasteSpecial
I usually use two paste special steps, with xlPasteValues and xlPasteFormats
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Dode" wrote in message ... I'm bringing in data from various worksheets into one worksheet - with each of the worksheets being copied into the last row. Problem : I'd like to change the existing script from PasteSpecial to paste so I do not loose the time format. Currently it is changing the data into a value (ie 12:00 AM = .05060) Have tried various wordings - pastevalue / value - but am not successful. thanks Windows("Extract data.xls").Activate With Sheets("Interval") lastrow = .Cells(.Rows.Count, "j").End(xlUp).Row Application.Windows(2).Activate Range("A1:J200").Copy .Cells(lastrow + 1, "j").PasteSpecial Paste:=xlAll End With |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why need to use Selection.PasteSpecial vs myRange.PasteSpecial | Excel Programming | |||
PasteSpecial | Excel Programming | |||
Pastespecial and cut | Excel Programming | |||
pastespecial in vba | Excel Programming | |||
pastespecial | Excel Programming |