Help! Excel UsedRange in VSTO changes when formatting cells.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I am knew to this whole VSTO thing and C# as well but the problem I am
having is actually with Excel. The UsedRange property from the Excel
object keeps assuming that when I format a cell with colors, that it is
used. It is NOT used. I want to have alternating colors on each row
without Excel thinking that it's used. Any ideas? I can't submit all
these unused rows because it's a time consumer!

.

Relevant Pages

  • Re: Cant insert row in Excel
    ... Gotta SAVE the workbook after you DELETE the unused rows. ... > My coworker can't insert a row in Excel 2000. ... Try to delete or clear the cells to the ...
    (microsoft.public.excel.misc)
  • Re: blank rows in linked table
    ... Excel maintains a UsedRange property for each worksheet, ... the rectangle from A1 to the bottom right cell that's ever ... worksheet to use Access will try to import or link the entire UsedRange. ...
    (microsoft.public.access.externaldata)
  • Re: Workbook size
    ... Sometimes Excel gets confused on what the used range is. ... the unused rows and Delete ... them (from the Edit menu, ... bigger then ...
    (microsoft.public.excel)
  • Re: Deleting
    ... That's the way excel works. ... You can hide those unused rows, ... They're not hurting anything and if ... Dave Peterson ...
    (microsoft.public.excel.misc)
  • Re: excel worksheet has fields that continue FOREVER!
    ... Some versions of Excel require a save and close then re-open. ... For more on resetting the used range see Debra Dalgleish's site ... >them out you need to highlight the unused rows, ...
    (microsoft.public.excel.misc)