I have a xlsm workbook from which I am using application.run and passing a parm to a sub in another .xlsm.
The sub in the second .xlsm is executing and setting a variable to a value. I am trying to return the variable value back to the first .xlsm and set a cell value to it.
I am having trouble getting the variable value returned back to the first .xlsm
What if I also wanted the second sub to set several variable values and have all of them returned to the original sub?
Thanks
The sub in the second .xlsm is executing and setting a variable to a value. I am trying to return the variable value back to the first .xlsm and set a cell value to it.
I am having trouble getting the variable value returned back to the first .xlsm
What if I also wanted the second sub to set several variable values and have all of them returned to the original sub?
Thanks