yuryyuryyury
New Member
- Joined
- Jul 3, 2007
- Messages
- 19
In cell C6, I have this formula:
Since I don't know how long column B would be, I picked a large number. Is there a way to incorporate a Range("A65536").End(xlUp) in there somehow?
Code:
=C5*(SUMPRODUCT(ABS($B13:$B2011)))
Since I don't know how long column B would be, I picked a large number. Is there a way to incorporate a Range("A65536").End(xlUp) in there somehow?