View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sai Krishna[_2_] Sai Krishna[_2_] is offline
external usenet poster
 
Posts: 29
Default display cell only if it contains a value

Hi,

I am trying to make an invoice template where rows are used to display name
of product, price etc. The invoice size should automatically be small if
there are only few rows. In other words, there should not be any blank rows
displayed when there is no item.

I should not manually hide blank spaces, but rather want the invoice to
shrink to the number of used rows containing positive values and not even ""
values that may be embedded in formulas.

Regards
sai