I'm sure you could do something like that...however, there are many formats
to a cell and I believe you may have to reference them individually in your
code. Just a guess though.


"Dave" wrote in message
...
Is there any way to store the format of a certain cell into a variable?
For
example:

frmt = Range("A1").format

... Then I could do something like:

function sum_format(rng)
for each rn in rng
if (rn.format = frmt) then
temp = temp + rn
end if
next
sum_format = temp
end function

In which the function would sum all cells that only have the format as
cell A1