Set focus to cell?
Range("C14").Select
HTH. Best wishes Harald
skrev i melding
...
After applying a 'column hide' I wish to set focus to a particular cell to
stop the columns being 'highlighted' after the user switches those columns
back on...
Yes I cannot find the .setFocus property in the vba intellisense..does not
seem to exist..any ideas on how to simply set focus to cell after doing
this:
Range("C:M,R:R").EntireColumn.Hidden = True
Selection.EntireColumn.Hidden = True
btnSH.Caption = "Show Columns"
|