This above Macro copies a range from Sheet "Variables" and pastes into AlgoTester so on and so on.
This works perfectly if the values in Sheet "Variables" only contain values with no formulas.
I would like to have the range in Sheet "Variables" contain formulas and have the Macro only COPY and PASTE the values of that range.
As of right now it will not function properly without that change.
I know the fix is in this line here: SpecialCells(xlConstants, xlNumbers) , but not sure what the exact code would be for this.
Can anyone help me out with this?
Thanks!
Bookmarks