Guinaba
Board Regular
- Joined
- Sep 19, 2018
- Messages
- 218
- Office Version
- 2016
- Platform
- Windows
Hi experts,
I have the formula below helping me to create an index col in my sheet, However, this is making my code too slow.
Does anyone know how to convert it to dictionary structure?
With Range("c2", Range("c" & Rows.Count).End(xlUp))
.Offset(0, -2).FormulaR1C1 = "=COUNTIF(R1C[2]:RC[2], RC[2])"
End With
I have the formula below helping me to create an index col in my sheet, However, this is making my code too slow.
Does anyone know how to convert it to dictionary structure?
With Range("c2", Range("c" & Rows.Count).End(xlUp))
.Offset(0, -2).FormulaR1C1 = "=COUNTIF(R1C[2]:RC[2], RC[2])"
End With