F
FARAZ QURESHI
I have the following piece of code for inserting a formula on a shortcut key
instead of typing the same manually.
Sub InsertFormula()
ActiveCell.Formula = "=sumproduct(--(a1:a10<>0),b1:b10)"
End Sub
Any idea how to select the ranges:
a1:a10
&
b1:b10
via "Single" Input Box (like type:=8) with 2 fields for selecting the ranges?
AND also
via "Two" separate Input Boxes for the same purpose?
instead of typing the same manually.
Sub InsertFormula()
ActiveCell.Formula = "=sumproduct(--(a1:a10<>0),b1:b10)"
End Sub
Any idea how to select the ranges:
a1:a10
&
b1:b10
via "Single" Input Box (like type:=8) with 2 fields for selecting the ranges?
AND also
via "Two" separate Input Boxes for the same purpose?