same range

  1. L

    VBA CountIfs with multiple criteria from same range

    Good morning/afternoon all I'm trying to figure out how to use CountIfs for a monthly Management report strictly using VBA. I can do it using arrays in excel formulas, but the language barrier from Formula to VBA is just beyond me at the present. Here's what I got so far. Dim ws1 As...
    • Lres81715
    • Thread
    • countifs multiple critera same range vba vba & excel 2013
    • Replies: 3
    • Forum: Excel Questions
  2. P

    How to use the cell selected by an inputbox and use it to loop through all files/workbooks

    Hello, I am attempting to figure out how to prompt the user to type in the cell label he/she wants from an inputbox and then automatically use that same cell address in all the files I want to loop through. I want to prompt the user only once, and not every time the code loops through each...

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