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

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

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

On Thu, 26 Apr 2007 17:33:50 -0400, "PCLIVE"
wrote:

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