Excel formulas are powerful, but they have their limits. I used to rely on complex nested formulas that take forever to build and are difficult to troubleshoot, but I have started leaning more heavily ...

Problem:<BR>Where a VBA procedure has been developed referencing specific cells, the user of the spreadsheet then decides to insert a new row or col, which has the affect of offsetting all of your ...