Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel VBA - Convert Cell Value (String) to Formula

Status
Not open for further replies.

amourdevin

Technical User
Sep 7, 2003
21
US
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!
 
ActiveCell.Formula = ActiveCell.Offset(X,Y).Text

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top