Indirect question

[vividor]

my question is about using indirect instructions

See the following columns of my report:

Error
Code Comments
A1 Payment Not Made
A8 Payment Made Early
Blank #REF!

when I put the code A1 on the error code column a message will auto-fill the comments column..... but if the error code cell is blank ..... I will get this error message "#REF".
How do I hide that error or eliminate the error?? Any suggestions ?? : ) Thanks
This message was edited by vividor on 2002-08-24 13:30
This message was edited by vividor on 2002-08-24 13:30

 

[Aladin Akyurek]

On 2002-08-24 13:28, vividor wrote:
my question is about using indirect instructions

See the following columns of my report:

Error
Code Comments
A1 Payment Not Made
A8 Payment Made Early
Blank #REF!

when I put the code A1 on the error code column a message will auto-fill the comments column..... but if the error code cell is blank ..... I will get this error message "#REF".
How do I hide that error or eliminate the error?? Any suggestions ?? : ) Thanks
This message was edited by vividor on 2002-08-24 13:30
This message was edited by vividor on 2002-08-24 13:30

If this is not VBA, what formula are you using in the "Comments" column?

 

[vividor]

My Error Code is in column H15, there are not formulas there, we just type a code number "A1,A8, etc".
Now, in the Comments column, I typed "=INDIRECT(H15)" in which a message will display depending on the code,A1=Payment Not Made, A5=Incorrect Amount, etc. But if I do not type any code then I get a "#REF!" message.
Is there any way to fix that or hide it by changing the font color to white?

 

[Aladin Akyurek]

On 2002-08-24 16:46, vividor wrote:
My Error Code is in column H15, there are not formulas there, we just type a code number "A1,A8, etc".
Now, in the Comments column, I typed "=INDIRECT(H15)" in which a message will display depending on the code,A1=Payment Not Made, A5=Incorrect Amount, etc. But if I do not type any code then I get a "#REF!" message.
Is there any way to fix that or hide it by changing the font color to white?

=IF(LEN(H15),INDIRECT(H15),"")

 

[vividor]

it works great!! thanks