vba formulas

  1. K

    Dynamic Sum Range Addresses...(?)

    I'm not really sure what you'd call what I'm trying to do, but here's my best attempt to describe it. I'm creating a summary sheet that will pull from an unknown number of sheets. I've employed Indirect to assist me as I hate #REF errors should referenced sheets get deleted. I have my macro...
  2. Z

    [VBA] Vlookup formula with Dynamic Workbook

    Hello, I have a problem setting a Vlookup formula with VBA. When I run the Macro a fileDialog appears asking me for the location of the file several times but that happens just when I use (File as the workbook) This is my formula Public File As a Workbook Dim NBF As Range Set File =...
  3. T

    VBA Formula to have excel send out an email message once a certain cell reaches below a certain quantity

    Hi, Just looking for some help as I have limited knowledge when it comes to VBA. What I'm trying to do is have an email send out to two individuals once a certain cell reaches below a certain number. The excel spread sheet tracks our stock quantities of a particular item and we want to be...
  4. C

    How do I divide 2 cells using VBA on a subtotal line

    Hello there, I have a simple subtotal macro where the last column, not included in the subtotal, needs to have the subtotals divided. This column has other results supplied by our financial system. As an example, column 11 is the result of column 10 / column 9. The subtotal macro subtotals...
  5. M

    VBA - Insert Sumif formula into cell - formula contains references to different worksheets

    I am trying to have vba enter a sumif formula into cell E8 on the sheet named "EOC" Based on the sumif formula (below) here is the information I have: =sumif(range, criteria, sum range) Range: The range for the sumif formula is column AF of a particular sheet. The sheet however will change...
  6. S

    using first and last row in Sum formula

    Have several regions on a sheet- trying to sum up cells in each region. Can determine the row numbers for the first and last rows of each region but am looking for a way to use that in a sum formula. Here is where I'm at: in the selected cell, I would like to put a formula that will add all...

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