View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carl Rapson Carl Rapson is offline
external usenet poster
 
Posts: 14
Default How to tell if a range or cell is dirty

Is there any way to tell if any of the cells in a range have been changed? I
have a VBA routine that allows the user to "auto-fill" a range of cells with
a certain value, but if any of the cells in the range have been modified but
not saved, I want to inform the user and (maybe) save the changes first. I
can't seem to find any property that indicates whether a range or a specific
cell has changed or not. Is there such a property, or maybe a way to compare
the current cell contents with the previous cell contents?

Thanks for any information,

Carl Rapson