View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jason Morin[_2_] Jason Morin[_2_] is offline
external usenet poster
 
Posts: 24
Default UDF - detect cell border

I'm struggling with a simple UDF (it might require 2). I'd
like to return TRUE/FALSE if a cell has a top *or* bottom
border. Something like:

Function IsBorder(cell As Range) As Boolean
IsBorder = cell.Borders(xlEdgeTop)
End Function

Thanks!
Jason