VBA Error "Automation Error Exception Occured"

I made a VBA Macro that will be below. I have been using the VBA for the past few days on a file that contains 11 different sheets. The VBA is taking the text in one sheet and trying to find similar text in another sheet. The program requires user input on what row to start the search for both sheets, which sheets to look at, and which columns to look at. I then have a form button to activate the macro as I was just to dumb to figure out how to use the activex button. I can't post the file itself for confidentiality reasons. To put my issue simply, there are certain columns I have been using the program to compare that are significantly "longer" than other columns, it has a lot more text (usually between 200and 800 characters). When I use the program to run this code it works fine for the longer text and it typically works fine for the shorter columns when I compare those. However for some reason 1 specific combination of the shorter comparisons breaks the program every time. For the life of me I can't figure out what is causing the problem. And yes before anyone asks, my coding isn't pretty, but it usually works so ¯\_(ツ)_/¯

What I've tried
Stepping through code: My god it takes so long based on how the program runs but no issues when I do that
Going into VBA and hitting run: Works, issue seems to only occur when I hit the form button
Checking references in tools: Everything seems to be there

Please Login or Register  to view this content.

any ideas on what could be causing the issue?

Through a lot of testing ive found the cells that make the program "break" and ive tested those cells in separate sheets. the program works just find when I compare those cells to each other in separate sheets that I create with just the problem cells. I cant figure out why the program can compare these cells just fine when they are isolated but it cant compare them while they are inside their original sheets.