View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ken Johnson Ken Johnson is offline
external usenet poster
 
Posts: 1,073
Default formatting question

Hi anny,

I've noticed that clearing the contents of any cell outside the range
M8:M37 results in the beep and the cleared cell being reselected (if
Enter is set to move down).
This can be cured by moving the first instance of "End If" down 6 lines
so that it is either the line before or the line after after the second
instance of "End If".

Ken Johnson