Range to array: how to get formats?

[volodium]

Hi, I'm trying to put values and formats of cells to an array to faster process them.

this seems to work

dim area as variant
area = range("a10:z20").value

This doesn't

dim areaformat as variant
areaformat = range("a10:z20").font.bold

Is there a way to quickly get font and .numberformat and .interior to an array without looping"?

thanks

 

[Andrew Poulsom]

No, sorry.

 

[Rick Rothstein]

As Andrew said, the answer to your question is "No"... the only properties that you can specify are Value, Value2 and Formula... I am not aware of any others.