ExcelBanter - Set focus to cell?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Set focus to cell? (https://www.excelbanter.com/excel-programming/319714-set-focus-cell.html)

No Name

Set focus to cell?

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"

Harald Staff

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"

All times are GMT +1. The time now is 11:07 AM.