View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SEF SEF is offline
external usenet poster
 
Posts: 5
Default Ignore Blank Cells

I update a workbook weekly in separate worksheets. My master worksheet links
to the appropriate cells for the updated data. These are simple percentage
numbers (not forumlas, etc.) and only need to be a one-on-one link. The
problem I have is that if one of the cells is blank, it returns a 0 and I
need to to stay blank. Any ideas? There are about 57,000 cells I am working
with so I really don't want to have to update manually all blanks.