Thread: Border VBA
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Border VBA

add a weight

Range("DCard1:DCard1a")..Borderaround Weight:=xlThin

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"SOS " wrote in message
...
Rob,

I found that when I tried your code of:

Range("DCard1:DCard1a").BorderAround

it didn't do anything to the range and even after adding

(xlContinuous)

to the end of the line it only put a border around the whole selection
rather than round each cell in the selection.

Am I missing something?

Regards

Seamus


---
Message posted from http://www.ExcelForum.com/