[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 282
  • Last Modified:

Change count to Sum

Hi i have the following lines of code that counts Columns+Rows.

Can i change this to sum?

rngYesterday.Columns.Count
rngYesterday.Rows.Coun

Thanks
Seamust
0
Seamus2626
Asked:
Seamus2626
  • 2
1 Solution
 
patrickabCommented:
Try:

worksheetfunction.Sum(rngYesterday)
0
 
Cory VandenbergSenior Risk ManagerCommented:
Can you elaborate what you are trying to sum?  The values in the columns and rows, by columns separately, by rows separately, or sum the # of Columns and # of Rows?

Your question is a little vague.
0
 
Seamus2626Author Commented:
Perfect, thats done the trick.

Thanks Patrick
0
 
patrickabCommented:
Seamus2626 - Thanks for thegrade - Patrick
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now