abberyfarm
Well-known Member
- Joined
- Aug 14, 2011
- Messages
- 733
Hello,
The code below counts the number of rows, my question is, how would you count the number of visible rows?
also
How would you calculate the sum of the visible rows in column D, from D2 downwards?
I'm trying to write a formula,
Thanks for the help
john
The code below counts the number of rows, my question is, how would you count the number of visible rows?
Code:
Totalrows = ch1.Range("D" & Rows.count).End(xlUp).Row
also
How would you calculate the sum of the visible rows in column D, from D2 downwards?
I'm trying to write a formula,
Code:
Prob = "Subtotal sum of column D" / The number of visible cells"
Thanks for the help
john
Last edited: