Hi
i am trying to enter sumproduct formula in macro & my formula is
=SUMPRODUCT($B6:EE6,$B$4:$EE$4)
& i want range $EE$4 to be dynamic while running macro in other sheet
Can somebody please show me how to do it? I'm rather new to Excel and couldn't quite follow the other threads about dynamic ranges.
Thanks a lot!!!