How do I stop line on chart - Pste-specl-values (BLANKS) in VB
 

When I am using VB with a Button to (copy, paste special-values) blanks, the
chart shows the blanks as zeros unless I manually delete all the blank
cells????