When I do want values, I get formulas.
I am trying to copy a formula from A1 to A2 through A20, I get the value A1 all the way down. Used to have to use $A$1 to get this type of result.
If I put Sheet1!A18, I get =Sheet1!A18, when I went the value of that A18 not the formula. What setting is causing that?
Using office 2018, but "xls" because of macros.
Bookmarks