billandrew
Well-known Member
- Joined
- Mar 9, 2014
- Messages
- 743
Can someone assist in dividing a cell by all cells in range. Something like this.
I have lr as follows:
Thank You
I have lr as follows:
Code:
Dim lr As Long: lr = Range("B" & Rows.Count).End(xlUp).Row
Code:
range("D2:D" & lr) = "C2/sum("C2:C" & lr)"
Thank You