Let's say my spreadsheet has cells A1 through A3 that look like
123 456 789
Those are the values that display but they are calculated by formulas in the cells.
I want a macro that will copy those three values (not the formulas) and past them in three cells
wherever my active cell happens to be.
The following works except that it copies/pastes the formulas themselves instead of the "123 456 789":
Seems like it should be easy!
I have one reference book "Microsoft Excel 2019" but I can't find something this simple.
Google turns up lots of stuff but everything assumes the data to be copied is simple numerical or text values,
not the results of a formula.
123 456 789
Those are the values that display but they are calculated by formulas in the cells.
I want a macro that will copy those three values (not the formulas) and past them in three cells
wherever my active cell happens to be.
The following works except that it copies/pastes the formulas themselves instead of the "123 456 789":
VBA Code:
Range("A1:A3").Copy Destination:=ActiveCellSeems like it should be easy!
I have one reference book "Microsoft Excel 2019" but I can't find something this simple.
Google turns up lots of stuff but everything assumes the data to be copied is simple numerical or text values,
not the results of a formula.
