ranges of cells

  1. MarkSELA

    Multiple choice question generator using randomly selected Excel ranges

    I downloaded and installed xl2bb but my Windows 11 system is refusing to unblock it. I've tried unblocking it through system settings but no success. I've tried placing the add-in in a trusted folder and still not working. I am designing a worksheet which will generate a random selection of math...
  2. B

    I'd like to have more than one dynamic range copied on top of each other

    Hey! So as the title explains, I have some sheets with different dynamic ranges, which I'd like to copy into one sheet. Here's the code I have so far: Workbooks("220312_Workplan_PP_AP.xlsm").Worksheets("Workplan").Range("C6:D2000").Copy _ Workbooks("MO_LD.xlsm").Worksheets("MO").Range("A5")...
  3. A

    Getting VBA in Excel NOT to print certain ranges where Total is = 0

    Hey Guys/Ladies, My code currently selects a set number of Named Ranges to print.. It prints everything. Even zero totals..aaargh. I need help getting VBA code not to print "Ranges" in worksheets where the "Total" any given table is " 0 ". Sub PrintCDivSum() 'error trap added for...
  4. A

    help getting VBA code not to print "Ranges" in worksheets where the "Total" any given table is " 0 ".

    Hey Guys/Ladies, My code currently selects a set number of Named Ranges to print.. It prints everything. Even zero totals..aaargh. I need help getting VBA code not to print "Ranges" in worksheets where the "Total" any given table is " 0 ". Sub PrintCDivSum() 'error trap added for...
  5. C

    Finding Average of a range based on values in another range

    This is what I want to do. I need to find the average value in Column B that is in between two numbers (or more accurately between the range of two numbers) in column A. For example I want to find the average column B value that is in between 2000 and 2001. Column A Column B 2002...
    • cyglor
    • Thread
    • average averageif criterion range countif ranges of cells
    • Replies: 4
    • Forum: Excel Questions

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