mysum

  1. D

    Macro sums values in some cells but not in others (or only partially)

    Hello! I have Microsoft Home and Student 2013. I have a macro that loops through all worksheets that contain letter "P": Sub MonthSumsH() ' Calculate the sum total in column H across all sheets that have letter P in their name Dim ws As Worksheet Dim LR As Long Dim MySum As Long Dim MyCell...
  2. F

    how to get the same result faster? please see VBA file.

    please see file uploaded in OneDrive. https://1drv.ms/x/s!AlfEVNV8SKm1dzv_eCrlCJVyLHc currently, it takes more than 20 seconds to complete a simple calculation. i am sure that there have to be a better and faster way to get the same result. but i wish i had that big brain like you experts...
  3. P

    Long Variable Type Overflow

    Hi Everyone, I'm getting the VBA run-time error 6, "Overflow." I've defined what I think are the applicable variables as long, and I think that should be enough for my purposes. I have Dim dArray(0 to 9), mySum As Long and the problem is at the line where two 10-digit numbers are being added...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top