Super slow VBA code on Intel Core i7 with Max RAM

Hard to say without seeing a sample of the workbook, there are a lot of loops being looped.

1. Reduce the number of times VBA reads from or writes to excel.

2. Reduce the number of actions in a loop

eg:

Please Login or Register  to view this content.

In this scenario If your cell contains 1, you go through 5 if statements to return "Bad"

Try This
Enter this line outside your loop

Please Login or Register  to view this content.

Inside your loop enter

Please Login or Register  to view this content.

3. Use Excel to do what excel does best and VBA to do what it does best.

In your code you do something like this twice:-

Please Login or Register  to view this content.

If h_rec_count = 1000

Then you are reading 1000 excel cells into VBA one at a time

Looking for some text in each cell

If you find the text you are modifying a cell in excel.

It is a lot faster to use a helper column.

a. Insert a formula in an empty column to do the hard work.
b. Copy Paste your Values from your helper column into your Ammended Column
c. Clear your Helper column.

So three lines of code and no loop as opposed to your 1000 loops and six lines of code.

Hi,

You should definitely turn Screenupdating off at the start of the code. Also avoid selecting things. And using Worksheetfunction.Index here is unnecessary

Please Login or Register  to view this content.

when you can just use

Please Login or Register  to view this content.

What's the purpose of this section of the code?

Please Login or Register  to view this content.