View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DB042188 DB042188 is offline
external usenet poster
 
Posts: 4
Default 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?