Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help needed with Countif....
I'm trying to use the following function in VBA:
=COUNTIF(B2:B2005,B14) Where B2 will never change, B2005 is determined by the following code: Application.WorksheetFunction.CountA(Worksheets("w orking data").Range("A1:A65536")) and B14 is the column B and the current row of a table. I have tried : iteration = Application.WorksheetFunction.CountIf(Worksheets(" working data").Range("A1:K" & rcount + 1), "B" & rowx) where rowx is predefined as 2, and incremented by 1 each time a go through the loop....but al I get back on this is a big - fat - zero. What am I doing wrong ? Thanks ! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
help needed with Countif....
maybe...
with worksheets("working data") iteration = Application.CountIf(.Range("A1:K" & rcount + 1), _ .range("B" & rowx)) end with Eric @ BP-EVV wrote: I'm trying to use the following function in VBA: =COUNTIF(B2:B2005,B14) Where B2 will never change, B2005 is determined by the following code: Application.WorksheetFunction.CountA(Worksheets("w orking data").Range("A1:A65536")) and B14 is the column B and the current row of a table. I have tried : iteration = Application.WorksheetFunction.CountIf(Worksheets(" working data").Range("A1:K" & rcount + 1), "B" & rowx) where rowx is predefined as 2, and incremented by 1 each time a go through the loop....but al I get back on this is a big - fat - zero. What am I doing wrong ? Thanks ! -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
help needed with Countif....
Thanks for the suggestion Dave - I wish I had better results...I got "Object
doesn't support this property or method" as an error. Anyone else have other ideas ? Thanks ! "Dave Peterson" wrote: maybe... with worksheets("working data") iteration = Application.CountIf(.Range("A1:K" & rcount + 1), _ .range("B" & rowx)) end with Eric @ BP-EVV wrote: I'm trying to use the following function in VBA: =COUNTIF(B2:B2005,B14) Where B2 will never change, B2005 is determined by the following code: Application.WorksheetFunction.CountA(Worksheets("w orking data").Range("A1:A65536")) and B14 is the column B and the current row of a table. I have tried : iteration = Application.WorksheetFunction.CountIf(Worksheets(" working data").Range("A1:K" & rcount + 1), "B" & rowx) where rowx is predefined as 2, and incremented by 1 each time a go through the loop....but al I get back on this is a big - fat - zero. What am I doing wrong ? Thanks ! -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
help needed with Countif....
I'd guess that there was something wrong with rcount or rowx.
But that's a guess. I didn't see how you set those variables to anything. Eric @ BP-EVV wrote: Thanks for the suggestion Dave - I wish I had better results...I got "Object doesn't support this property or method" as an error. Anyone else have other ideas ? Thanks ! "Dave Peterson" wrote: maybe... with worksheets("working data") iteration = Application.CountIf(.Range("A1:K" & rcount + 1), _ .range("B" & rowx)) end with Eric @ BP-EVV wrote: I'm trying to use the following function in VBA: =COUNTIF(B2:B2005,B14) Where B2 will never change, B2005 is determined by the following code: Application.WorksheetFunction.CountA(Worksheets("w orking data").Range("A1:A65536")) and B14 is the column B and the current row of a table. I have tried : iteration = Application.WorksheetFunction.CountIf(Worksheets(" working data").Range("A1:K" & rcount + 1), "B" & rowx) where rowx is predefined as 2, and incremented by 1 each time a go through the loop....but al I get back on this is a big - fat - zero. What am I doing wrong ? Thanks ! -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
help needed with Countif....
I solved it - here's how the code looks now (tested and works):
iteration = Application.WorksheetFunction.CountIf(Worksheets(" working data").Range("B1:B" & rcount), Worksheets("working data").Range("B" & rowx)) I'm glad I worked this on out, the bruise on my forehead from hitting the wall too many times was getting rather large ! "Dave Peterson" wrote: I'd guess that there was something wrong with rcount or rowx. But that's a guess. I didn't see how you set those variables to anything. Eric @ BP-EVV wrote: Thanks for the suggestion Dave - I wish I had better results...I got "Object doesn't support this property or method" as an error. Anyone else have other ideas ? Thanks ! "Dave Peterson" wrote: maybe... with worksheets("working data") iteration = Application.CountIf(.Range("A1:K" & rcount + 1), _ .range("B" & rowx)) end with Eric @ BP-EVV wrote: I'm trying to use the following function in VBA: =COUNTIF(B2:B2005,B14) Where B2 will never change, B2005 is determined by the following code: Application.WorksheetFunction.CountA(Worksheets("w orking data").Range("A1:A65536")) and B14 is the column B and the current row of a table. I have tried : iteration = Application.WorksheetFunction.CountIf(Worksheets(" working data").Range("A1:K" & rcount + 1), "B" & rowx) where rowx is predefined as 2, and incremented by 1 each time a go through the loop....but al I get back on this is a big - fat - zero. What am I doing wrong ? Thanks ! -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif help needed | Excel Worksheet Functions | |||
Help needed on possible countif.. | Excel Discussion (Misc queries) | |||
countif formula needed | Excel Discussion (Misc queries) | |||
CountIf Function Help Needed | Excel Worksheet Functions | |||
Countif help needed | Excel Discussion (Misc queries) |