vba countif

[SQUIDD]

Hi All

trying to work out why the below will not give me my answer

Range("'app'!$C$4").Value = WorksheetFunction.CountIf(Worksheets("Meeting").Range("g2:g30"), ">1")

trying to make sheet "app" cell c4 = the count of cells in sheet "meeting" in range G2:g30 that are more than 1.

any ideas, i just get 0

much appriciated

dave

 

[Joe4]

You cannot use worksheet names inside of your range declaration. Try:

Sheets("app").Range("C4").Value = WorksheetFunction.CountIf(Worksheets("Meeting").Range("g2:g30"), ">1")

 

[SQUIDD]

Hi Joe

thanks, but still not working

Sheets("App").Range("C4").Value = WorksheetFunction.CountIf(Worksheets("Meeting").Range("G2:G30"), ">1")

but then i put the formula in the cell to check, and i had nothing >1, i had to use >"". The data is actually a string rather than a number derived from a formula
feel stupid now, thanks for the help

Dave

 

[Joe4]

but then i put the formula in the cell to check, and i had nothing >1, i had to use >"".

Well, of course it isn't going to work if you change the conditions it was originally based on!

trying to make sheet "app" cell c4 = the count of cells in sheet "meeting" in range G2:g30 that are more than 1.

Try:

Sheets("app").Range("C4").Value = WorksheetFunction.CountIf(Worksheets("Meeting").Range("g2:g30"), ">""")

 

[SQUIDD]

many thanks joe.

all working 100%

cheers

dave