Hello all, first post here.
I am having an issue with excel not saving a new formula in specified cells. Here is some background:
Within the cells of my workbook: certain cells have the following function contained in the cell: =function_name(data1,data2,data3,etc........)
I made edits to the VBA code called "function_name" which requires me to adjust the cell input to the following: =function_name(data1,data X,data2,data3,etc........)
where "data X" is a new value I pass to the cell.
When I make the change to add the cell containing " Data X" it works fine. When I save and refresh my workbook this change does not get saved and I have to re-add data X to the cell every time I want to run the function.....
How do I make this change permanent?
Thanks!
I am having an issue with excel not saving a new formula in specified cells. Here is some background:
Within the cells of my workbook: certain cells have the following function contained in the cell: =function_name(data1,data2,data3,etc........)
I made edits to the VBA code called "function_name" which requires me to adjust the cell input to the following: =function_name(data1,data X,data2,data3,etc........)
where "data X" is a new value I pass to the cell.
When I make the change to add the cell containing " Data X" it works fine. When I save and refresh my workbook this change does not get saved and I have to re-add data X to the cell every time I want to run the function.....
How do I make this change permanent?
Thanks!