By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 1,915 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

Formatting the border of a range when automating excel

P: n/a
Hi Folks
hope someone can help me out with this wee problem. I'm automating
Excel from A2K and want to put a solid black border around a range of
cells.
I've tried using this:

ExcelSheet.Application.Worksheets("Sheet1").Range( "D9:D12").Borders.Color
= vbBlack

but it puts a border around each cell in the range, not just around
the range itself. Would much appreciate knowing the right way to do
this.

many thanks

Laurence
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.