Get Cells with border

[sheen]

Hi,

I have an excel sheet with different cells having borders. e.g Range A1:d12 has a border. Then another range like A20:D40 has a border. Now i like to write a macro which automatically detects these ranges with borders and color the cells which are in these border ranges.

I hope i am elaborative enough. Incase there is any ambiguity, do let me know.

Thanks in advance.

 

[Joe Was]

Duplicate post:

See:

http://www.mrexcel.com/board2/viewtopic.php?t=232877

 

[sheen]

Thanks for the reply..

Actually i want the macro to detect these ranges automatically and color them.Any idea..?

 

[Joe4]

Please do not start a new thread. Continue on in your original post.