View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
michael.beckinsale michael.beckinsale is offline
external usenet poster
 
Posts: 274
Default ActiveCell.Value just disappears .... ?

Hi Ray,

IsEmpty tests the condition of a variable and if l believe what l am
told is said to be unreliable.

Suggest you change to something like;

If ActiveCell.Value < "" Then

...........rest of code

Regards

Michael