ActiveWorkbook.PrecisionAsDisplayed = True
tmp() = Range("A1:A20")
but, PrecisionAsDisplayed = True will change your data in your sheets
On Fri, Oct 15, 2010 at 1:49 PM, The Frog <mr.frog.to....@googlemail.com>wrote:
> Hi everyone,
>
> First time posting to this group. Glad to have found it. I have a
> question regarding capturing cell data into an array in VBA. If I use
> the following code:
>
> tmp() = Range("A1:A20")
>
> I can capture the values of these cells into my array. This seems to
> produce a double as the data type, and in my current situation there
> are many digits after the decimal place. The displayed value on the
> sheet is formatted so that only one decimal place is shown. What I
> would like to do is to capture the values into the array as shown on
> the worksheet. Does anyone have a 'rapid' way of achieving this rather
> than cell by cell iteration? I need to keep this macro as fast as
> possible as it can be working with many tens of thousands of cells.
> The above code captures the range into the array near instantly.
>
> Cheers
>
> The Frog
>
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
