![]() When I attempt to trace the error of the cell in the "Calculations" sheet, and attempt to go to the cell in "Input" sheet, it claims the reference is invalid. However, when it does this, suddenly the functions don't work. ![]() I have a macro in the second workbook which attempts to define values in the "Input" sheet of the first workbook. However, I have a second excel workbook which interacts with the first. Now if I'm just using the sheet itself everything works perfectly fine and the functions work. These functions are used in the "Calculations" sheet, but reference cells in the "Input" sheet. I've written in a few custom functions to calculate certain things. I have one excel workbook which has two sheets in it: "Input" and "Calculations". ![]() I've attempted to track down and solve this error for hours now and I just can't figure it out.
0 Comments
Leave a Reply. |