Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CountA formila for a varying range
Sub Count()
Dim Work As Workbook Dim Figures As Workbook Set Work = Workbooks.Open("N:Work.csv") Set Figures = Workbooks.Open("N:\Figures June.xls") Work.Activate Range("A1").Select RngA = Range(Selection, Selection.End(xlDown)).Select Figures.Activate ActiveCell.FormulaR1C1 = "=COUNTA(DALWork!R1C1:RngA)" 'ActiveRange = "=COUNTA(Selection)" 'RngA states True End Sub What should I put in the formula instead of RngA? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Programatically Extend The Formila In A Cell | Excel Programming | |||
dynamic range counta error | Excel Programming | |||
Using Counta with a range | Excel Programming | |||
AutoFill down a varying Range | Excel Programming | |||
Range varying in for loop | Excel Programming |