79169444

Date: 2024-11-08 09:28:07
Score: 0.5
Natty:
Report link

I tried it using the attached workbook and the below code, if worked for me:

Sub test()
   Dim i As Integer
   i = 3
   ActiveSheet.Range("A" & i).Formula = "=COUNTIFS('SpreadsheetA'!J:J,TEST!B" & i & ",'SpreadsheetA'!D:D,"" > ""&Control!C5)"
End Sub

See attached images for the data. Omage 1

Image 2

Image 3

Image 4

Reasons:
  • Whitelisted phrase (-1): worked for me
  • Probably link only (1):
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: MyExcelDeveloper.com