VBA Syntax for using a variable in a worksheet function
 

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

VBA Syntax for using a variable in a worksheet function
 

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



"xjetjockey" wrote:

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

VBA Syntax for using a variable in a worksheet function
 

Perfect. Thank you so much.

JMB wrote:
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



"xjetjockey" wrote:

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

VBA Syntax for using a variable in a worksheet function
 

Glad to help.

"xjetjockey" wrote:

Perfect. Thank you so much.

JMB wrote:
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



"xjetjockey" wrote:

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