| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VB count word occurence in variable size sheet
Me again folks, sorry.
System report will be variable number of rows deep, I have macro that's running sweetly but counter in VB is set to big number to make sure all lines calculated. I need to be able to count he occurences of "NPQ" in the sheet, this will give me correct counter number for vb. How do I do count? How do I refernce answer in the macro? cheers in advance for all your wonderful help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VB count word occurence in variable size sheet
myVal = application.countif(activesheet.cells,"NPQ")
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "JBW" wrote in message ... Me again folks, sorry. System report will be variable number of rows deep, I have macro that's running sweetly but counter in VB is set to big number to make sure all lines calculated. I need to be able to count he occurences of "NPQ" in the sheet, this will give me correct counter number for vb. How do I do count? How do I refernce answer in the macro? cheers in advance for all your wonderful help |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VB count word occurence in variable size sheet
If you are trying to use this count value as the terminating value in a loop
then try:- Sub stance() For x = 1 To Application.CountIf(ActiveSheet.Cells, "NPQ") 'Your macro Next End Sub Mike "JBW" wrote: Bob, If I use that in my macro it'll count the NPQ for me, but how do I use the naswer in my for Counter = 1 to 100 line? "Bob Phillips" wrote: myVal = application.countif(activesheet.cells,"NPQ") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "JBW" wrote in message ... Me again folks, sorry. System report will be variable number of rows deep, I have macro that's running sweetly but counter in VB is set to big number to make sure all lines calculated. I need to be able to count he occurences of "NPQ" in the sheet, this will give me correct counter number for vb. How do I do count? How do I refernce answer in the macro? cheers in advance for all your wonderful help |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VB count word occurence in variable size sheet
Bob,
If I use that in my macro it'll count the NPQ for me, but how do I use the naswer in my for Counter = 1 to 100 line? "Bob Phillips" wrote: myVal = application.countif(activesheet.cells,"NPQ") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "JBW" wrote in message ... Me again folks, sorry. System report will be variable number of rows deep, I have macro that's running sweetly but counter in VB is set to big number to make sure all lines calculated. I need to be able to count he occurences of "NPQ" in the sheet, this will give me correct counter number for vb. How do I do count? How do I refernce answer in the macro? cheers in advance for all your wonderful help |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VB count word occurence in variable size sheet
For cntr = 1 To myVal
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "JBW" wrote in message ... Bob, If I use that in my macro it'll count the NPQ for me, but how do I use the naswer in my for Counter = 1 to 100 line? "Bob Phillips" wrote: myVal = application.countif(activesheet.cells,"NPQ") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "JBW" wrote in message ... Me again folks, sorry. System report will be variable number of rows deep, I have macro that's running sweetly but counter in VB is set to big number to make sure all lines calculated. I need to be able to count he occurences of "NPQ" in the sheet, this will give me correct counter number for vb. How do I do count? How do I refernce answer in the macro? cheers in advance for all your wonderful help |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VB count word occurence in variable size sheet
Thanks worked a treat
"Bob Phillips" wrote: For cntr = 1 To myVal -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "JBW" wrote in message ... Bob, If I use that in my macro it'll count the NPQ for me, but how do I use the naswer in my for Counter = 1 to 100 line? "Bob Phillips" wrote: myVal = application.countif(activesheet.cells,"NPQ") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "JBW" wrote in message ... Me again folks, sorry. System report will be variable number of rows deep, I have macro that's running sweetly but counter in VB is set to big number to make sure all lines calculated. I need to be able to count he occurences of "NPQ" in the sheet, this will give me correct counter number for vb. How do I do count? How do I refernce answer in the macro? cheers in advance for all your wonderful help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to count occurence of multiple characters in a cell | Excel Worksheet Functions | |||
| count occurence and present results | Excel Worksheet Functions | |||
| Using Sumproduct to count text occurence | Excel Worksheet Functions | |||
| Count the occurence of more than one condition | Excel Worksheet Functions | |||
| I need to count the occurence of text in a range of cells (which . | Excel Worksheet Functions | |||
Linear Mode
