Howdee all.
I have a formula that I'm trying to set up to enter as a VBA-User Form macro.
Everything works... except.....
When I go to enter it as a formulaArray it spits out an error message, and in my research to find out why, I've learned that FormulaArray has a 255 character limit for strings.

My final equation that will show up in the cell is only 187 characters in length, but I've found that VBA actually reads the workbook's name into with the external:=true reference for function.
In the case of workbook name being added to the equation, it winds up being 263 characters in length.

As not all file names are the same length-- some are much longer, and as not all sheet names would be the same length, I need to trim the name of something off, and am not sure how, or even if, I can do this.

As I'm pulling data off another worksheet within the same workbook, I would really like it to have the sheet name reference without having the workbook name reference.

So, my question is:

How can I keep the name of the workbook from being included in my equation, while still retaining an external:=true reference in the , or can I set up a shorter means of accomplishing this and still obtain only what I need?

Thank you.