Store the format of a cell in a variable

[Dave]

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

 

[PCLIVE]

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.

 

[tbone]

I agree - you have to pick one or more specific format items. For
example, I've used interior.colorindex for a similar purpose.

HTH
tbone