How to change empty ranges from a plot series without generating e
 

I am writting a macro that updates the range of a set of series in a plot.
The issue is that some of the ranges contain empty cells. When trying to
change the ranges of series with empty values excel returns the error "Unable
to set the Values property of the Series class".

Any ideas