amourdevin
Technical User
I am a newbie teaching myself from a book. Thanks in advance for any assistance and patience offered.
I have a cell value that contains text (string). The value could otherwise be a valid formula expression [e.g., =SUM(A1:A2)] but for the moment it is only a value in a cell. Can this value be picked up and used as a formula using VBA? Can it be referenced inside a formula [ActiveCell.FormulaR1C1 = "=...(ActiveCell.Offset(X,X).Value))..."]?
Thanks in again!
I have a cell value that contains text (string). The value could otherwise be a valid formula expression [e.g., =SUM(A1:A2)] but for the moment it is only a value in a cell. Can this value be picked up and used as a formula using VBA? Can it be referenced inside a formula [ActiveCell.FormulaR1C1 = "=...(ActiveCell.Offset(X,X).Value))..."]?
Thanks in again!