deselect vba

  1. D

    Clearing ListBox Selection

    I'm using the code below to hide or unhide and activate worksheets in my workbook. I would like to add code to deselect the original selection in the listbox, however when I try to add code to several places I receive a Run-Time 9 error, subscript out of range. Private Sub lbSheets_Change()...
  2. B

    how to deselect selected Ranges

    i use an excel workbook with several excel sheets. after running a makro, some ranges in some sheets are selected. how can i deselect them? (due to optical reasons) This does not work: - Application.Goto Reference:=Worksheets("Tabelle1").Range("A1") - Application.CutCopyMode = False...

Some videos you may like

This Week's Hot Topics