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.

--
Regards,
Tom Ogilvy

" wrote in message
oups.com...
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.

Thanks Tom .....
I'm surprised you don't ask for a fee for all this knowledge....

wrote:
Thanks Tom .....
I'm surprised you don't ask for a fee for all this knowledge....

Perhaps because after trying

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

a refund would be in order.

Alan Beban