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()...
    • dhosi439
    • Thread
    • deselect vba for and next statements list box userform
    • Replies: 2
    • Forum: Excel Questions
  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

Top