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