View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alex Lai Alex Lai is offline
external usenet poster
 
Posts: 1
Default How To Trap Cell Value Change Event so determine XL calc sequence?

Hi ALL,

I am trying to write a procedure that can trap the cell value change event
so I can prorammatically determine in what sequence Excel calculates cells
in a worksheet: A1, A2, A3....B1, B2, B3..


or A1 B1, C1...A2, B2, C2?

Any ideas? thanks

Alex