Cyclic Error yielded by calculation be replaced by blank or something from
previous posts figured it cannot be achieved by formulas ...well was
wondering is it possible with Macros ? If so , how ? Guru's could you throw
some light on this :)
thx ~Raj

Are you referring to Circular Reference errors?

"Raj" wrote:

Cyclic Error yielded by calculation be replaced by blank or something from
previous posts figured it cannot be achieved by formulas ...well was
wondering is it possible with Macros ? If so , how ? Guru's could you throw
some light on this :)
thx ~Raj

I refer to this error #DIV/0!
New to Excel World....
I was thinking of replacing this error with blank or something using some IF
clause seems that doesn't work as point by Tom .

I am curious if this could be achieved by MACROS? if so ,any steps described
could be helpful
thx
Raj




"JLGWhiz" wrote:

Are you referring to Circular Reference errors?

"Raj" wrote:

Cyclic Error yielded by calculation be replaced by blank or something from
previous posts figured it cannot be achieved by formulas ...well was
wondering is it possible with Macros ? If so , how ? Guru's could you throw
some light on this :)
thx ~Raj

Here are a couple of causes of the #DIV/0 error notice and recommended cures.
I am not sure what you mean by replacing the notice unless you mean to
prevent getting the notice. Maybe this will help.

Cause: Using the cell reference to a blank cell or to a cell that contains
zero as a divisor

Note If the operand (operand: Items on either side of an operator in a
formula. In Excel, operands can be values, cell references, names, labels,
and functions.) is a cell that is blank, Microsoft Excel interprets the blank
as zero.

Change the cell reference to another cell.
Enter a value other than zero in the cell used as a divisor.
Enter the value #N/A into the cell referenced as the divisor, which will
change the result of the formula to #N/A from #DIV/0! to denote that the
divisor value is not available.
Prevent the error value from displaying, using the IF worksheet function.
For example, if the formula that creates the error is =A5/B5, use
=IF(B5=0,"",A5/B5) instead. The two quotation marks represent an empty text
string.

Cause: Running a macro that uses a function or a formula that returns #DIV/0!

Make sure the divisor in the function or formula is not zero or blank.


"Raj" wrote:

I refer to this error #DIV/0!
New to Excel World....
I was thinking of replacing this error with blank or something using some IF
clause seems that doesn't work as point by Tom .

I am curious if this could be achieved by MACROS? if so ,any steps described
could be helpful
thx
Raj




"JLGWhiz" wrote:

Are you referring to Circular Reference errors?

"Raj" wrote:

Cyclic Error yielded by calculation be replaced by blank or something from
previous posts figured it cannot be achieved by formulas ...well was
wondering is it possible with Macros ? If so , how ? Guru's could you throw
some light on this :)
thx ~Raj