beginvbaanalyst
Board Regular
- Joined
- Jan 28, 2020
- Messages
- 141
- Office Version
- 365
- Platform
- Windows
Hello,
I'd like to transfer this macro recorder into an unlimited cell countif in cell E2.
I don't see where my value in "a2" is being recorded?
Range("E2").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "=COUNTIF(C[2],RC[-4])"
Range("E2").Select
Selection.AutoFill Destination:=Range("E2:E159")
Range("E2:E159").Select
I'd like to transfer this macro recorder into an unlimited cell countif in cell E2.
I don't see where my value in "a2" is being recorded?
Range("E2").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "=COUNTIF(C[2],RC[-4])"
Range("E2").Select
Selection.AutoFill Destination:=Range("E2:E159")
Range("E2:E159").Select