I wish to reduce the number of characters in a formula that is placed in a cell from a macro. My problem is the formula uses too many characters and by reducing the number of characters in the formula all works great.
Can I used "DIM As Worksheet" then reference the "New Name" in the formula for all to work. The current longer names of the worksheets need to remain for other reporting processes.
I have attached a simulation workbook for testing please use as required.
Any assistence with this problem is greatly appreciated.