Store the format of a cell in a variable
 

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

Store the format of a cell in a variable
 

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

Store the format of a cell in a variable
 

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