MATLAB Answers

katerina
1

Deselect Cells on Excel Sheet

Asked by katerina
on 12 Dec 2014
Latest activity Answered by Othmane ELMOUATAMID on 12 Nov 2018
Hello, I am writing a report out to an Excel Workbook, and everything is correct except that I cannot deselect the cells after I've selected them. What is the correct keyword to accomplish this?
Here's the part of code in question:
Excel.Cells.Select;
Excel.Selection.HorizontalAlignment = 2;
%Excel.Selection.Unselect; %this returns an error (no method Unselect)
%Excel.Selection.Deselect; %this returns an error (no method Deselect)
I don't want my users to have to open their workbooks with all highlighted cells - it's pretty annoying. Does anyone know the answer to this??
Thank you!

  0 Comments

Sign in to comment.

1 Answer

Answer by Othmane ELMOUATAMID on 12 Nov 2018

Hello Katerina,
Try to select one cell then Excel will unselect all other cells, for instance select the very first cell of your sheet: Range("A1").Select

  0 Comments

Sign in to comment.