Cell Value vs Text

[snowdyce]

Hello Everyone,

I had a quick question. If I want to pull the text value of a cell vs the Actual Value, how do I do that. For example, I am use to using something like

Worksheets("Sheet2").Cells(6, 4).Value

Say the Cell Text is =2+2. The above would provide a Value of 4. How would I select the text of the cell, to get the "=2+2"?

Thanks,
Sean

[Teeroy]

Use the .Formula property:

Worksheets("Sheet2").Cells(6, 4).Formula