help in formatting cells
 

Hi !!!!!!!!!!!!!!!!!!!!!!!!!!!

I need to do something like

sub sTest()
dim strTest as string

strTest=".interior.colorindex=10"

with range("A1")
strTest ' basically formatting the range with a variable input
end with

end sub

This is just a dummy code. I need to do this as I have a range which
has different formats for different cells within the range.
I would like to store the formats in an array and apply it to the range
based on the key value or something.


Thanks !

help in formatting cells
 

See response in .programming

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


wrote in message
ups.com...
Hi !!!!!!!!!!!!!!!!!!!!!!!!!!!

I need to do something like

sub sTest()
dim strTest as string

strTest=".interior.colorindex=10"

with range("A1")
strTest ' basically formatting the range with a variable input
end with

end sub

This is just a dummy code. I need to do this as I have a range which
has different formats for different cells within the range.
I would like to store the formats in an array and apply it to the range
based on the key value or something.


Thanks !