Hi Luc, What you describe is what I am looking to do, but the order of the matching cells matters. Cell A1 of the range has to be C1 etc... :)

VBA will continue to work. Corporations won't upgrade Excel if Microsoft killed VBA since so many macros have been written. Upgrading Visual Basic (not VBA for Excel) to VB .NET is a nuisance. If you had to port a significant amount of code, you also could consider C#. I personally prefer to use Excel C API as much as possible, and a minimal amount of VBA.