Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Statement then Calc
Can some one get me started in the right direction to look at colunm (B) If
name is present add how many names are in colunm B in cell B65. (Note I only may have a name in B5 thru B62) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Statement then Calc
Range("B65").Value = application.CountA(range("B5:B62"))
-- Regards, Tom Ogilvy "Kelly********" wrote: Can some one get me started in the right direction to look at colunm (B) If name is present add how many names are in colunm B in cell B65. (Note I only may have a name in B5 thru B62) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Statement then Calc
the formula doesnt seem to do anything. I dont understand application.CountA
Iguess. "Tom Ogilvy" wrote: Range("B65").Value = application.CountA(range("B5:B62")) -- Regards, Tom Ogilvy "Kelly********" wrote: Can some one get me started in the right direction to look at colunm (B) If name is present add how many names are in colunm B in cell B65. (Note I only may have a name in B5 thru B62) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Statement then Calc
It isn't a formula - it is VBA code. You are posting in Programming. If you
want a formula to place in cell B65 use =CountA(B5:B62) -- Regards, Tom Ogilvy "Kelly********" wrote: the formula doesnt seem to do anything. I dont understand application.CountA Iguess. "Tom Ogilvy" wrote: Range("B65").Value = application.CountA(range("B5:B62")) -- Regards, Tom Ogilvy "Kelly********" wrote: Can some one get me started in the right direction to look at colunm (B) If name is present add how many names are in colunm B in cell B65. (Note I only may have a name in B5 thru B62) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
If And/Or statement for comm calc criteria | Excel Discussion (Misc queries) | |||
Calc = Manual & Do Not Calc b/4 SAVE | Excel Discussion (Misc queries) | |||
My calc key on Excel changes box to "Text" Box and doesn't calc ? | Charts and Charting in Excel | |||
auto calc on, but have to edit (f2) cells to force re-calc..help! | Excel Worksheet Functions |