if range("c22").value = "" then 'it has no data
range("c22").value = 0
end if

i think that's what you want.
:)
susan


On Nov 13, 11:32*am, Lav wrote:
Embarressing I thougth I knew the answer

My macro populates the cell if the relevant cell it is reading from
(in another wb has data in it).

If there is no data in it how do I put a 0 in that cell (C22)?

Thanks