How to detect if a cell has border and where?

[JohnPoole]

Hi all, I'm hoping somebody can advise how to write a small vba script which will look at cell and determine if it has border, and on which sides?

I've tried the example from help with a few variations, but cant seem to get it working.

Any advice appreciated.

 

[Jon von der Heyden]

Hi John

Just popping back between meetings so I don't have time for a comprehensive answer. The basics would be to use the function as is, but evaluate cells surrounding rngCell. That is you pass the range to the 1st argument of the function, e.g. C10. So you could build a procedure that loops up, down, left and right, with an exist at the point at which it identifies a border...

Bit of a hasty reply but hopefully gives some direction.

 

[JohnPoole]

The theory sounds good, but I suspect I will need help implementing it. Thanks for the help.