Turn all excel sheet background to white

I'm trying to turn all the excel background color into white.

WB.Worksheets.Item().Range().Interior.ColorIndex=2;

I'm not sure what to put in for both () to have it look for all the areas with datas.

How to set excel cell color to red from Matlab? - MATLAB Answers - MATLAB Central (mathworks.com)

[dpb]

I don't recall what it's called OTOMH, but there's a property (or method?) that does return the used range in the workbook -- search for the Excel VBA doc for some phrase similar and you'll likely get a link the the MSDN VBA doc's that you can crib from the example code.

Answer 1

[dpb]

<docs.microsoft.com/...vba/api/excel.worksheet.usedrange>