If Problems.....

[Macnautor]

Hi I am trying to write a macro that will put text into the nominated cell. The macro needs to look at 3 cells in a range, on my worksheet they are D35, D36 and D37. If one of these cells contains the phrase "Hypothesis Null Rejected" then the macro should return the Phrase A. If all three cells = "hypothesis null not rejected" then the macro should return phrase B.

My problem is that I can't get it to look at all three, it only returns a phrase based on the 3rd cell. I don't know how to fix this.

This is the code I am using;

Please Login or Register  to view this content.

I should probably tell you that I have only been writing VBA code for exactly a week now. I am self-taught and basically fumbling in the dark, so any help would be great!!!!!

[Cutter]

Without looking past the 2nd line:

Remove the quotes from the numbers 35 and 37

[arlu1201]

Try this

Please Login or Register  to view this content.

[Cutter]

And you haven't Dim'ed i.

[Macnautor]

I have tried both suggestions and this is still returning the phrase based on the value in D37.

When you say Dim'ed i? what exactly do you mean?

[Macnautor]

I have also tried this code;

Please Login or Register  to view this content.

[Cutter]

When you say Dim'ed i? what exactly do you mean?

You 'declared': Result As String, Conc As String
but you didn't 'declare': i as Integer

[Macnautor]

Thanks for your help so far Cutter, but this has not helped, it still is only chaging the value of B40 based on the result from the last "i" in the group C37.

[Cutter]

Why don't you just have a formula sitting in cell B40?

Like:
=IF(COUNTIF(D35:D37,"Hypothesis Null Rejected"),"The t-Test could prove that the sample mean was different to the population mean",IF(COUNTIF(D35:D37,"hypothesis null not rejected")=3,"The t-Test could Not prove that the sample mean was different to the population mean",""))

[Cutter]

That could possibly be shortened to:

=IF(COUNTIF(D35:D37,"<>")=3,"The t-Test could "&IF(COUNTIF(D35:D37,"*not*")=3,"Not ","")&"prove that the sample mean was different to the population mean","")

[Pulsus]

Macnautor,

Try this code, it´s a little bit "Barbarian" but worked fine here:

Please Login or Register  to view this content.

[Macnautor]

Cutter, thanks for your help, however I want to use a macro to do it, I want to learn vba.

pulsus, thanks for that, I will try that when I return to the computer.

[protonLeah]

Or maybe:

Please Login or Register  to view this content.

[Macnautor]

ProtonLean

Thanks but for some reason, you code did not fill with phrase b, but did with phrase a?

Pulsus

Your code was the same as ProtonLean, however, I understood yours a little more, (I think its because I am a little barbaric!) so I was able to edit it to produce the correct result, here is the code I used;

Please Login or Register  to view this content.

Thank you for your help, I would not have been able to finish this tonight if it wasn't for your input.

Thanks again to all who had input to this thread.

[Pulsus]

Macnautor,

Fine It works. Unfortunately sometimes we need to win by force...