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