joycesolomon
New Member
- Joined
- Aug 2, 2011
- Messages
- 48
Hi,
I am trying to count the total rows that has value in a column,
is my syntax correct
Dim lrC As Long
lrC = Cells(Rows.Count, "ActualKeep!$B").End(xlUp).Row
Range("Actual!B2").Formula = "=COUNTA(ActualKeep!$B$2:$B$" & lrC & ")"
I am trying to count the total rows that has value in a column,
is my syntax correct
Dim lrC As Long
lrC = Cells(Rows.Count, "ActualKeep!$B").End(xlUp).Row
Range("Actual!B2").Formula = "=COUNTA(ActualKeep!$B$2:$B$" & lrC & ")"
