Turn all excel sheet background to white

8 views (last 30 days)
Emily
Emily on 6 Sep 2022
Answered: dpb on 7 Sep 2022
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.
  1 Comment
dpb
dpb on 7 Sep 2022
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.

Sign in to comment.

Answers (1)

dpb
dpb on 7 Sep 2022

Categories

Find more on Data Export to MATLAB in Help Center and File Exchange

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!