PDA

View Full Version : [SOLVED] Cell Value vs Text



snowdyce
10-30-2012, 01:13 PM
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:motz2:

Teeroy
10-30-2012, 02:06 PM
Use the .Formula property:


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