syntax problem
hello to all
I have a code line...
ActiveCell.Formula = "=COUNT(P5:P15)"
But the rowOffset won't always be 10. I've defined a rowOffset, called
RowOff, but I can't get the syntax to work with the COUNT function?
Something like ...
ActiveCell.Formula = "=COUNT(P5:P ***RowOff goes in here somehow*** )"
thanks
Dorre
|