I can't give you an exact answer, but have you looked at the columns or rows
properties and have you designated a range?

David

"JPlankenhorn" wrote:


I am working on a VB6 app that is creating an Excel report. I load the
data onto the spreadseet using an array. I would then like to modify
the properties of the first 5 columns of every fourth row to have a
bottom border. I am able to do this with a loop that applies the
change, however, it is kind of slow. I was wondering if there is a way
to loop through the table, select the rows I want to change and then
apply that change to the selected set of rows?


--
JPlankenhorn
------------------------------------------------------------------------
JPlankenhorn's Profile: http://www.excelforum.com/member.php...o&userid=37567
View this thread: http://www.excelforum.com/showthread...hreadid=571974