Rounding Entries From Range to Array

  • Thread starter Thread starter marston.gould
  • Start date Start date
M

marston.gould

I'm loading a range into an array by
using the statement:

Dim x As Variant
x = Range("NamedRange")

Is there a fast an easy way to round all of the items either
as they are loaded into the array or after? I need to round
it to 2 decimal places. Or do I have to loop through the entire array.
 
Looping through the array is what you have to do, but it isn't that slow
usually.
 
Thanks Tom .....
I'm surprised you don't ask for a fee for all this knowledge....
 
Thanks Tom .....
I'm surprised you don't ask for a fee for all this knowledge....
Click to expand...
Perhaps because after trying

x = Application.Round(Range("NamedRange"), 2)

a refund would be in order.

Alan Beban
 
Norm,
Appreciate the support and kind words, but I am willing to admit when I am
wrong. I am happy to be wrong in this case; apologize to Marston for the
misinformation and kudos to Alan for giving the correct response. I am
certainly willing to refund all that Marston has proferred. <g>

Regards,
Tom Ogilvy
 
Aww shucks, Tom; now you've gone and outdone me in the felicitousness
department.

No harm intended; I just couldn't resist one that Marston so well teed up.

Alan Beban
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array to Multiple Arrays 3
Baffled with assignment of range to array why won't it work??? Anyhelp appreciated 4
Read a range into an array 9
Copy Array to Array, how to and should I? 13
How to read Excel Array to vb.net Arrays? 20
Arrays and scattered cell values or another way? 16
Eliminate Variant Array Elements 2
Rounding problem 9

Back
Top