View Single Post
 
Old 04-07-2020, 01:52 PM
ChrisOK ChrisOK is offline Windows 10 Office 2019
Advanced Beginner
 
Join Date: Sep 2016
Posts: 54
ChrisOK is on a distinguished road
Question

I updated the test file again just now to
"A2" only (for the Len Range)

and then changed O2 to NOT have quotes on either side of the formula and it pasted the result of the formula (not the formula)

If I put the quotes back, it pastes the formula with quotes and therefore does not function as a formula
Reply With Quote