View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin McCartney Kevin McCartney is offline
external usenet poster
 
Posts: 67
Default Freezed Panes and CTRL+HOME

Hi TWIMC,

On a workbook, if you have Frozen Panes and then you press CTRL+ HOME, the
selected cell becomes the cell directly below where the intersection of the
frozen panes.

So the question is there a way to perform a CTRL+HOME in VBA code without
using the dreaded Sendkeys?

TIA
KM