View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin Porter Kevin Porter is offline
external usenet poster
 
Posts: 38
Default Code for dealing with #REF

I have some fields that end up #REF because of deletes that are done. I
would like to look at that field, if it contains #REF then I want that field
to be the sum of all the columns in that row. If it doesn't then I want it
to equal what it equals.

Thanks,

Kevin Porter