| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding colors, patterns, comments to large spreadsheets in bulk
Never looked at vba/excel before, but was able to reduce run time on an app
by 75% via recorset streamlining. Still not happy with run times, learned that manipulation of cells is consuming most of the other 25%. Learned that perhaps adding values in bulk to spreadsheet (rather than one by one) would probably improve performance drastically. So I'm wondering if the pretty substantial color, pattern and comment manipulation we're also doing can somehow be applied in bulk, perhaps from an array or similar workaround? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Colors and/or Patterns in the Same Line | Charts and Charting in Excel | |||
| Comments at End of Large Table | Excel Discussion (Misc queries) | |||
| Patterns in excel printing as solid colors (not as selected) | Excel Discussion (Misc queries) | |||
| excel does not shows colors or patterns in screen, but will print | Excel Discussion (Misc queries) | |||
| linking comments between spreadsheets | New Users to Excel | |||
Threaded Mode
