Hello:
I need to define a range in a macro that I apply to different size spreadsheets and I need one of the values to be a formula result or the value of a cell, I'll use SUM as an example: instead of SUM(A1:K200) I need something like SUM(A1: (=COUNTIF(data, "<>""") + 5) or just
SUM(A1: Value(Z1)) where Z1 contains the result of a formula.
Can this be done?
Thanks in advance.
M.
I need to define a range in a macro that I apply to different size spreadsheets and I need one of the values to be a formula result or the value of a cell, I'll use SUM as an example: instead of SUM(A1:K200) I need something like SUM(A1: (=COUNTIF(data, "<>""") + 5) or just
SUM(A1: Value(Z1)) where Z1 contains the result of a formula.
Can this be done?
Thanks in advance.
M.