H
Hazel
Hi All
Having a hard time with the following
Private Sub Add1_Click()
Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("Customers")
Worksheets("Customers").Select
Tb1.Value = Application.CountIf(Range("J3:J600"), "35") <<<< Working ok
What I need is
Tb1.Value = Application.CountIf(Range("J3:J600") ' ws("Prices") Range ("A2")
so that if I change the price from "35" to 40 in ("A2")("Prices") it will
count the "40" in the "Customers" sheet.
Is this possible please - over 2 hours down the line and still no further
forward.
Having a hard time with the following
Private Sub Add1_Click()
Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("Customers")
Worksheets("Customers").Select
Tb1.Value = Application.CountIf(Range("J3:J600"), "35") <<<< Working ok
What I need is
Tb1.Value = Application.CountIf(Range("J3:J600") ' ws("Prices") Range ("A2")
so that if I change the price from "35" to 40 in ("A2")("Prices") it will
count the "40" in the "Customers" sheet.
Is this possible please - over 2 hours down the line and still no further
forward.