Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy paste in correct data
I'm trying to coping and paste the contents of cell, and I'm pasting
something, just not the correct data. In the cell that I'm coping is the value 1 the value that gets pasted if 1/1/1900 Here is the code that I'ce got Debug.Print rngFind.Offset(0, 2).Value // prints one in the Immediate window which is correct jnk = rngFind.Offset(0, 2).Value //jnk is = "1" x.Offset(0, 8).Value = jnk // the celvalue is 1/1/1900 Debug.Print x.Offset(0, 8) // prints 12/31/1899 in the Immediate window Any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy paste in correct data
Peter,
Looks like the cell is formatted as date type. something like Range(yourrange).NumberFormat = general should give you 1 in the cell. "Peter" wrote in message ... I'm trying to coping and paste the contents of cell, and I'm pasting something, just not the correct data. In the cell that I'm coping is the value 1 the value that gets pasted if 1/1/1900 Here is the code that I'ce got Debug.Print rngFind.Offset(0, 2).Value // prints one in the Immediate window which is correct jnk = rngFind.Offset(0, 2).Value //jnk is = "1" x.Offset(0, 8).Value = jnk // the celvalue is 1/1/1900 Debug.Print x.Offset(0, 8) // prints 12/31/1899 in the Immediate window Any ideas? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy paste in correct data
Yes, in the sheet I'm copying from, those cells have that upper corner
green tag to them and the error is that this cell is formatted as text or proceeded by an apostrophe. So I got that thanks "Project Mangler" wrote in message ... Peter, Looks like the cell is formatted as date type. something like Range(yourrange).NumberFormat = general should give you 1 in the cell. "Peter" wrote in message ... I'm trying to coping and paste the contents of cell, and I'm pasting something, just not the correct data. In the cell that I'm coping is the value 1 the value that gets pasted if 1/1/1900 Here is the code that I'ce got Debug.Print rngFind.Offset(0, 2).Value // prints one in the Immediate window which is correct jnk = rngFind.Offset(0, 2).Value //jnk is = "1" x.Offset(0, 8).Value = jnk // the celvalue is 1/1/1900 Debug.Print x.Offset(0, 8) // prints 12/31/1899 in the Immediate window Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How copy none excel data & paste in 2007 without overwriting data | Excel Discussion (Misc queries) | |||
Copy and Paste data | Excel Programming | |||
filted data, copy and paste a col. puts data in wrong row how fix | New Users to Excel | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
IN AN IF FORMULA COPY STRING OF DATA IF A CELL IS CORRECT | Setting up and Configuration of Excel |