It depends on how you are using A1, B1, C1... to populate
the corresponding ranges. I am assuming here what is most
likely - that the cells in A5:A10 contain formulas that
depend on the value in A1, and when A1 is erased you are
getting error values such as #DIV/0! showing in the
cells. If that is the case, you can check for the error
values and suppress them, e.g.:

=IF(IsErr(put your formula here),"",(put your formula
here))

-----Original Message-----
How do I clear the contents from a range of cells, which
are dependent on another cell being populated. For
example, If I enter a Value in cell A1, A5:A10 are
populated with data according to the value entered in A1.
A value in B1 populates data in B5:B10, C1 populates data
in C5:C10 etc.....

My question is if I clear either A1,B1 or C1, I also want
to clear the corresponding data in A5:A10, B5:B10, C5:C10
etc

If I only clear A1 & C1 then contents from A range & C
range should only clear. Any ideas would be appreciated.
.