how to set region border

May 29, 2011 at 5:03 PM

I tried using CellRangeAddress to create ranges, then using SetBorderTopOfRegion to set the 4 borders of this region. But i found it really slow when running the program. Without setting the borders, my program can finish in seconds, but creating regions and setting the borders of the region can cost a dozen minutes.

Is there a better way to set the borders of a certain region?