Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bad PasteValues Operation with date
Hi,
What I'm basically doing is filling an excel worksheet from a recordset. As cells might contain numbers as well as text. Once pasted to Excel, I pasteSpecial the sheet, multiplying cells by 1 to get numbers. I'm encountering a strange behavior though. Here is the small piece of code: Dim xl As New Excel.Application Dim ws As Worksheet xl.Workbooks.Add Set ws = xl.ActiveWorkbook.Sheets(1) xl.Visible = True ws.Range("A1") = "'MAY 2007" ws.Range("B1") = 1 ws.Range("B1").Copy ws.Range("A1").Select xl.Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlMultiply, SkipBlanks:=False, Transpose:=False As you see, A1= MAY 2007, format forced to be Text by using '. My concern is that after the pastespecial, A1=39203 which I guess is the numeric representation of MAY 2007(?). Doing the exact same stuff from Excel will produce the expected behavior: A1='MAY 2007 B1=1 Copy B1 Select A1 PasteSpecial Values - Action Multiply A1 is still MAY 2007 as expected. Would someone have any tip to workaround the problem. Thanks, Olivier |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
.Copy Destination:= << Forget when PasteValues is desired | Excel Discussion (Misc queries) | |||
Change cut/paste operation to cut/insert operation | Excel Programming | |||
Conditional formatting, pastevalues, clearcontents | Excel Discussion (Misc queries) | |||
what does $ operation mean | New Users to Excel | |||
Operation on Ranges | Excel Programming |