Leave cell blank instead of returning #DIV/0!

[bradyj7]

Hi there,

I'm calculating the average acceleration of a vehicle every 10 seconds as it travels along. However sometimes no acceleration occurs in that 10 second time period and hence the #DIV/0! error is returned to the cell.

How can I make it leave the cell blank instead of returning #DIV/0! because it is effecting subsequent work.

Thank you

Aavg = Application.Subtotal(1, Worksheets("raw").Range(Cells(sp, 7), Cells(ep, 7)))
    Worksheets("kinematic").Activate
    ActiveCell.Offset(0, 9).Value = Aavg

 

[Steve=True]

If you are using 2007, can you use =Iferror

 

[wigi]

You already received code for that ...

http://www.mrexcel.com/forum/showpost.php?p=2821078

You even indicated it solved your problem

What's different in this topic?

 

[Jonmo1]

You already received code for that ...

http://www.mrexcel.com/forum/showpost.php?p=2821078

You even indicated it solved your problem

What's different in this topic?

This topic is about preventing the error in the first place.
The other topic is about using specialcells to remove the errors.

And, this thread actually came first (look at the time stamps).

 

[wigi]

A-ha, okay then