VBA Syntax for using a variable in a worksheet function

[xjetjockey]

Can someone help with a basic question?

This is the function which works in Excel:

=COUNTA(A337:A359)

I don't want to put it on the worksheet, but rather calculate it in my
VBA procedure.

I have two variables that identify the row numbers as follows: FFR =
row 337, and FTR = row 359.

I want the result of the above formula assigned to variable DayNum.

Any help would be greatly appreciated.

Thanks.

Robert

 

[xjetjockey]

Perfect. Thank you so much.

Try:

Sub Test()
Dim FFR As Long
Dim FRT As Long
Dim DayNum As Double

FFR = 337
FTR = 359

DayNum = Application.CountA(Range("A" & _
FFR & ":" & "A" & FTR))

End Sub

 

[Guest]

Glad to help.

Perfect. Thank you so much.