View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Situmorang Frank Situmorang is offline
external usenet poster
 
Posts: 97
Default Convert "" to real blank cell

Hello, I want to use the benefit of End xldown or UP on moving the cursor,
but It does not work if the cell is not really blank/no content at all. My if
statement produce " " in the cell which is not blank although it appreas
blank, So, I can not use my End xl down or up.

Can anybody help me how can I change it?, my formula is like this:
=IF(AG7=AG8,"","Ini").

Thanks in advance

Frank