Set focus to cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Slow Macro 3
Hide column based on data validation 0
Trying to hide all rows where no data is in columns AQ-AV 2
change cell value by code 6
Excel VBA 1
Macro for hiding columns not worling 3
set focus to form 18

Back
Top