ItalianPlatinum
Well-known Member
- Joined
- Mar 23, 2017
- Messages
- 843
- Office Version
- 365
- 2019
- Platform
- Windows
I am currently looping through a range and looking to also use that in a formula. Like so:
Looking to leverage FormCompList for it
VBA Code:
Dim CompList
Dim FormCompList As Range
'run for each
j = 0
Do Until WsFT.Range("CompList").Offset(j, 0) = ""
CompList = WsFT.Range("CompList").Offset(j, 0)
'OTHER CODE
ElseIf Comp <> "" Then
.Range("B2:B" & lr3).Formula2 = "=IFERROR(COUNTIFS(ALL!$C$2:$C$" & lr2 & ",FormComplist,ALL!$D$2:$D$" & lr2 & ",A2),0)"
j = j + 1
Loop
Looking to leverage FormCompList for it