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.