Hi All,
I just began getting the "Run-time error '1004': Unable to set the FormulaArray property of the range class" in my code.
Here's the block of code where I'm receiving the error
The formulas are all pretty much the exact same with some minor tweaks with where they are placing/pulling information, and the code errors on the 3rd line. The first two run fine. The formula also works fine if I manually place it in the correct cell.
I've uploaded a text file with just the VBA code for this macro, and a scrubbed version of the excel file. The issue I'm having is with the Add_Consultant macro (Module 12) specifically on the 'Summary' sheet.
I apologize for any mistakes in the files. I inherited this file to add a specific functionality to it, and I think many people have touched it over the years.
Thanks so much!
Joe
Bookmarks