| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select multiple rows and apply changes all at once
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select multiple rows not next to each other | Excel Worksheet Functions | |||
| select multiple rows and format | Excel Discussion (Misc queries) | |||
| How do I apply a formula to multiple rows at the same time? | Excel Worksheet Functions | |||
| Apply a simple formula to multiple rows? | New Users to Excel | |||
| how to select multiple rows using vba | Excel Programming | |||
Threaded Mode
