I probably should have said that I have code similar to this
aws.range("Range").value = ows.range("Range").value
The range is one cell. Let's say the displayed value on the oWS is
1.32, but the value when the cell is selected is 1.320102.
Barb
Dave Peterson - 16 Jan 2008 17:12 GMT
Maybe you can widen the column to see all the digits.
I'm confused about what you're selecting and what you're viewing...
If you're selecting the range on the aws worksheet and looking at the
formulabar, what do you see?
If you see the 1.320102, try widening the column or changing the numberformat of
the cell to what you want.
If you're selecting the ows range and see 1.320102 in the formulabar, but see
1.32 in the formulabar when you select the aws range, then I bet it's the format
of the original cell that's screwing you up.
Try:
aws.range("Range").value2 = ows.range("Range").value2
VBA's help for .value2 explains when .value can cause trouble.
> I probably should have said that I have code similar to this
>
[quoted text clipped - 4 lines]
>
> Barb

Signature
Dave Peterson
Hi Barb,
I can only reproduce this result using
[a2].value=[a1].text
But do check the replies you got from Dave
<the status of the Microsoft interface>
I guess you refer to the Ribbon, but I'm not sure. Can you elaborate on what your question is?

Signature
Kind regards,
Niek Otten
Microsoft MVP - Excel
| I'm trying to copy the values from one worksheet to another and I'm
| finding that the values that are displayed are what's copied, rather
[quoted text clipped - 4 lines]
| Thanks,
| Barb Reinhardt
Barb Reinhardt - 16 Jan 2008 20:52 GMT
I mean the Microsoft Web Interface for the newsgroup. That's how I
usually access it, but it doesn't seem to work.
> Hi Barb,
>
[quoted text clipped - 22 lines]
> | Thanks,
> | Barb Reinhardt