View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kazoo kazoo is offline
external usenet poster
 
Posts: 16
Default Help with Offset

I am using offset to copy some data from another worksheet. Unfortunately,
the number of rows varies from column to column.

If I drag the cursor down, it displays "0" in the cells that do not have any
data from the original worksheet. Is there a way to not display the "0"? I
want to plot this data so it doesn't work to just reformat the cell to not
display the "0". It also isn't an option to just drag the cursor down to a
certain point on each column since my data is dynamically changing.

Thanks!