Hi all, I've got another one for you today. This one might be complex but I highly doubt it. I'll do my best to explain the project below, I've attached a sample workbook if it helps.
All in all the workbook is designed to take the first worksheet and restructure it into a different format based on its contents. The button on sheet 1 runs a series of macros that do just that, and a lot of it is pretty straightforward and no doubt probably unnecessary. However, most of it works.
Where it doesn't seem to work is in the later stages: I have a function that searches the original array for a cell that has three corresponding values; "AlturaLookup" and the sub that generates the criteria for running AlturaLookup and loops it to populate the new format; "RunLookup"
Now AlturaLookup works just fine in a vacuum, and I know there's some issues with getting RunLookup to populate the table in the right way, but where I'm having particular trouble is in this section of RunLookup
Apparently
seems to work, no errors or anything, but it just skips to the EndIf, so it seems like I'm equating the two improperly. What I want it to do is essentially: "If there's an error, run the function until there is no error; otherwise change the value of a cell based on the various counters that are running"
Does that make sense?
Thanks in advance to anyone who reads this, hope it's not too long.
Bookmarks