I am having a problem where I paste the contents of an array in a range of
cells on a spreadsheet.

Where the value in the array is nil or blank and i paste it into the range
of cells, instead of blank cells I am getting the values inherited from the
cell above when it should be a blank or zero cell.

I would be grateful if anyone can solve this or offer a solution to the
problem.

Thanks

Patrick.