View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rowan[_2_] Rowan[_2_] is offline
external usenet poster
 
Posts: 226
Default F5 to solve freezing

Application.Goto Reference:="R5C2" replicates the F5 function. Whether that
will fix your unfreeze problem or not is another question.

Regards
Rowan

"MrT" wrote:

Hello,

I sometimes face some freezing problems (due to bugs with the Refedit
control) that can partially be solved by clicking the F5 key and then
selecting a cell to go to. This defreezes Excel. Does anyone know a way to
simulate that programmatically?

Thanks,

Mr. T