Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Countif
How do I modify this part of my macro so that I can use it
on a file that ends on row 20 instead of 13? I want to be able to use it on files that end on various rows. TIA ActiveCell.FormulaR1C1 = "=COUNTIF(R[-13]c:R[-1]C,0)" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Countif
"Brian" wrote in message ... How do I modify this part of my macro so that I can use it on a file that ends on row 20 instead of 13? I want to be able to use it on files that end on various rows. TIA ActiveCell.FormulaR1C1 = "=COUNTIF(R[-13]c:R[-1]C,0)" Fairly obviously you can do this manually ActiveCell.FormulaR1C1 = "=COUNTIF(R[-20]c:R[-1]C,0)" Or to do this programmatically: MyRows=20 ActiveCell.FormulaR1C1 = "=COUNTIF(R[-" & MyRows & "]c:R[-1]C,0)" You may also find this helpful: activesheet.usedrange.rows.count - it gives no of rows in use on current worksheet Geoff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
Countif ? | Excel Worksheet Functions | |||
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions |