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
