How would to insert a formula to sum up all data in the current range if
it matches a value without hardcoding a large number like the 1000th row
of column C ??
Code:
--------------------
Sheets("List").Select
ListRowCount = ActiveSheet.UsedRange.Rows.Count 'Unfiltered Data.
Sheets("Complete Issues").Activate
Range("D7").Formula = "=COUNTIF(List!C3:C1000,C7)"
' I Wish to use something like to select a dynamic row range based on a variable .... "=COUNTIF(List!(Range("C3")(C,ListRowCount)),C 7)" ????
OR something like....
StartRow = 3
EndRow = Cells(ActiveSheet.UsedRange.Rows.Count, "C").End(xlUp).Row
But i need help cos it dont work.
--------------------
--
tarns
------------------------------------------------------------------------
tarns's Profile:
http://www.excelforum.com/member.php...o&userid=32291
View this thread:
http://www.excelforum.com/showthread...hreadid=520437