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()...
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...