Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste results not as expected
First post, so please be gentle on me!!
I have a workbook with data exported from another DB which contain a mixture of dates number and times. These are mixed within the same columns. If I try to copy and paste to another worksheet or workbook within the same instance of excel the dates are not pasted as dates (even if I use paste special and select values only). The dates are formatted to the left by default. I have got around this by opening another copy of excel and then using paste special which gives me an entirley different dialog box and then I select text or csv as the paste special format. Thsi gives me dates as dates (formatted to the right by default) So far so good, but now I want to automate the copy ansd paste special I am using ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:= _ False This gives the original error of the dates not being true dates. Now they are formatted to the left by default and any calulation using the dates fails. The macro was recorded and does not work despite the fact that the original action that created the macro worked. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro won't paste results | Excel Discussion (Misc queries) | |||
unable to get expected results while anding two coloumns | Excel Discussion (Misc queries) | |||
Sumproduct not returning expected results | Excel Worksheet Functions | |||
Paste results consecutively within column (based off other worksheet) | Excel Worksheet Functions | |||
copy and paste cells to a different worksheet according to IF results | Excel Programming |