View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default 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"