Application.WorksheetFunction error

  • Thread starter Thread starter Ayo
  • Start date Start date
A

Ayo

This line of code is not working. Any ideas?

Worksheets(1).Range("B22").Value =
Application.WorksheetFunction.Sum(Range("B17:B20"))
 
Are there any worksheetfunctions that are returning and Error value in B17:B20?

HTH,
Bernie
MS Excel MVP
 
Thanks. I figured it out.
Worksheets(1).Range("B22").Value =
Application.WorksheetFunction.Sum(Worksheets(1).Range("B17:B20"))
I was missing the "Worksheets(1)." in the sum function.
 
Thanks. I figured it out.
Worksheets(1).Range("B22").Value =
Application.WorksheetFunction.Sum(Worksheets(1).Range("B17:B20"))
I was missing the "Worksheets(1)." in the sum function.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help with Application.WorksheetFunction 4
Case without Select Case error problem 2
Formula Cell color limitation 7
Excel Need assistance with modifying a Duplicate declaration. 13
IF FUNCTION 0
Reference Range Names in Macro 8
VBA error: "object doesn't support this property or method" 2
Lookup for the first occurrence 4

Back
Top