VBA Question

[DomoKing]

Hi All,

I want to know how do I make it so that for a set of 2 data bars on a chart, if the corresponding cells have N/A values, then it just won't show up on the bars at all. I am sure its just an if statement but not sure how to implement it, any advice would be well appreciated.

 

[Leandroarb]

Re: VBA Question Urgent!

Hi,

Do you can use this: "If(IsError(Expression);"";Expression)).

Regards!



|L|E|A|N|D|R|O| |B|A|R|B|O|S|A|
|S|O|L|I| |D|E|O| |G|L|O|R|I|A|

 

[DomoKing]

Re: VBA Question Urgent!

Thanks for the response, however I want to implement that in vba using macros, is there a way to translate the above expression into a macro expression? Thanks.

 

[njimack]

Re: VBA Question Urgent!

No need for VBA - amend your formula as follows...
=IFERROR(yourformula,NA())

 

[DomoKing]

Re: VBA Question Urgent!

But how do I do that without altering the original formulas in the cells?

 

[Stiuart_W]

Re: VBA Question Urgent!

Replace yourformula with =IFERROR(yourformula,NA())

 

[Leandroarb]

Re: VBA Question Urgent!

But how do I do that without altering the original formulas in the cells?

You will nest to the existing formula.

Example:

Existing formula: VLOOKUP(1,B1:C4,2)

If not exist value, the result is "NA"

With the "=IFERROR(": =IFERROR(VLOOKUP(1,B1:C4,2),"",VLOOKUP(1,B1:C4,2))

 

[Fluff]

Re: VBA Question Urgent!

Cross post https://www.excelforum.com/excel-programming-vba-macros/1218719-n-a-question-for-chart.html

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Leandroarb]

Re: VBA Question Urgent!

Cross post https://www.excelforum.com/excel-programming-vba-macros/1218719-n-a-question-for-chart.html

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Excuse me Mr. Fluff , but i don't understand. The answer #8 is to me?

 

[Stiuart_W]

Re: VBA Question Urgent!

Excuse me Mr. Fluff , but i don't understand. The answer #8 is to me?

No. It's aimed at the OP (Original Poster) of the thread