View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CP CP is offline
external usenet poster
 
Posts: 64
Default =Sheet1!A1 - with a blank entry!!!

Sheet1 A1 is transfered to a cell on Sheet 2 via =Sheet1!A1, I then print
sheet 2 - however sometimes cell A1 is left blank which is returning a 0
value on sheet2 - how can I have this so its left blank if no value is in
sheet1 a1??