VBA function not working as intended- Loop Problem?

[KrombopulosMichael]

Hello everyone, This is my first post here. I'm relatively new to using the deeper functions of excel. I have a little bit of experience with coding, but I typically only do so to make small programs that will make personal tasks more efficient.
I have a workbook that I am using for automotive tuning. The end goal is to take user entered data consisting of 3 elements per row, compare that data to a 17*17 table, calculate an average correction factor for each point, and apply that correction factor to the original table, yielding a corrected map that can then be loaded onto the ECU of the car.

I have done this using the following VBA code:

Please Login or Register  to view this content.

The issue I am having is that if the function encounters a set of data (or Column A and Column B combination) that lands it in the same cell as the previous cell, it does not add to my total correction table or visits table. IE if I had a set of data 50000 rows long where the index values of all data points to the same cell in my table, but provides a different correction factor for each sample, it only takes into account the first value and does nothing with the rest. If the function has to move to a new cell, and then back to a cell it has already visited, it works just fine however.

Also, unrelated: in my Histogram Sub, I could not get the loop to work properly by using

Please Login or Register  to view this content.

Any pointers would be greatly appreciated. As far as my logical reasoning skills tell me, Sub should do exactly what I wanted it to do, so I'm completely stumped. Thanks in advance!

[mehmetcik]

Khalispera.

We would like to help but

1.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)


2.

Attach a sample workbook