syntax problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dorre - 20 Mar 2006 03:54 GMT

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

Reply to this Message

Gary Keramidas - 20 Mar 2006 04:01 GMT

try
ActiveCell.Formula = "=COUNT(P5:P" & RowOff & ")"

Signature

Gary

> hello to all
>
[quoted text clipped - 9 lines]
> thanks
> Dorre

Reply to this Message

dorre - 20 Mar 2006 17:19 GMT

Close, but this evaluates to: ActiveCell.Formula = "=COUNT(P5:P10)"

I need to understand the syntax in adding an offset (rowOff) of, say 10, to
P5, resulting in an expression equivalent to: ActiveCell.Formula =
"=COUNT(P5:P15)"

Thanks. Dorre

> try
> ActiveCell.Formula = "=COUNT(P5:P" & RowOff & ")"
[quoted text clipped - 13 lines]
>> thanks
>> Dorre

Reply to this Message

Gary Keramidas - 20 Mar 2006 18:20 GMT

in this example, i just set RowOff to 10 for testing, is this what you want?

this will count p5:p20
Sub test()
RowOff = 10
ActiveCell.Formula = "=COUNT(P5:P" & 10 + RowOff & ")"
End Sub

Signature

Gary

> Close, but this evaluates to: ActiveCell.Formula = "=COUNT(P5:P10)"
>
[quoted text clipped - 20 lines]
>>> thanks
>>> Dorre

Reply to this Message