I have a follow up question to this if anyone would like to help?
Now that the closest match can be found, I thought that establishing the cell position would enable me to offset from that position to find another value in the workbook.
I've tried doing this but have had no success.
I have supplied a new workbook attachment with an altered code which supplies the same result called FindClosest, and also another code called FindClosest2 which I am trying to get to work to use the found closest match value, and offset from that cell and return the new designated cell value.
I'll show codes here too, incase they do not convert properly to .xls format as I am using excel 2007:
I hope someone can help, as this was my main objective. I thought I would be able to complete the last part, but being new to this use of coding I am stuck.
Thanks,
Yappa
Bookmarks