Thread: syntax problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dorre dorre is offline
external usenet poster
 
Posts: 12
Default 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