efficient looping

  1. N

    More efficient way of capitalizing all cells in a range

    Hi, I'm very new to VBA so apologies if this is a simple question. I was using a macro to capitalize all strings in two ranges. The current code I'm using looks like this: Dim x As Range For Each x In SuppliesList.Range("B" & FilledRows + 1, "C" & SourceRows + FilledRows) x.Value =...
  2. L

    Please help - how to optimize all the copying and pasting

    The code below is looking through items in Column A on sheet 'Key', then find match in Column A of sheet 'Match1' and copy the first 8 cells of each matched row on sheet 'Match1' to sheet 'Result'. Can you please look through the following questions by priority? Okay to not have all three...
  3. I

    VBA code efficiency requested - Comparing thousands of products and categories

    Hello, I am trying to do some analysis on a customer's sales history to identify what types of product they are buying. I have the list of products each customer buys. I have a list of the items and the categories of those products, and my aim is to step through each customer's sales...
  4. T

    Excel VBA - Loop through tables + if statements

    The code below works, however it is taking 8.5 seconds which in the big scheme of my whole workbook macros is ernomous. I have two input tables and one output table - Eligibility_Tbl </SPAN> and Exclusions_Tbl which determine whether </SPAN>Eligibility columns</SPAN> on the Data_Tbl </SPAN>is...

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