Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / January 2008

Tip: Looking for answers? Try searching our database.

Range values not being copied with same number of significant digits

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Barb Reinhardt - 16 Jan 2008 15:52 GMT
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
than the full value in the cell.  How do I get the entire value?

Also, does anyone know the status of the Microsoft interface.

Thanks,
Barb Reinhardt
Barb Reinhardt - 16 Jan 2008 16:38 GMT
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

Niek Otten - 16 Jan 2008 18:03 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.