Solved

Change count to Sum

Posted on 2011-02-25
4
271 Views
Last Modified: 2012-06-27
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
Comment
Question by:Seamus2626
  • 2
4 Comments
 
LVL 45

Accepted Solution

by:
patrickab earned 500 total points
ID: 34981899
Try:

worksheetfunction.Sum(rngYesterday)
0
 
LVL 18

Expert Comment

by:Cory Vandenberg
ID: 34982689
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
 

Author Closing Comment

by:Seamus2626
ID: 34995659
Perfect, thats done the trick.

Thanks Patrick
0
 
LVL 45

Expert Comment

by:patrickab
ID: 34995807
Seamus2626 - Thanks for thegrade - Patrick
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question