vba for converting results of a formula to text in a cell.

[erutherford]

Can a cell that contains the results of a "formula" i.e. "report!$A$1", which displays the text "repaired", be automatically converted to text?

if so could a sample be shown.

thanks in advance

 

[Sektor]

Copy -> Paste As Values

 

[erutherford]

Thanks. So Cell G7 has "=Report1!$G$7" in it, where does "Copy -> Paste As Values" plug in?

 

[MattH1]

Highlight the cell you want to have as a string (Cell G7 in this instance). Press Cntrl + C. Then Press Alt + E + S + V (not simultaneously, one after the other). This should change Cell G7 to say "repaired".

Please note that once you do this, the formula will be removed.

 

[erutherford]

Sheet1, cell C184 contains this function "=LOOKUP(B184,A13:A177,B13:B177 & C13:C177)". the function returns text. I'll click on the command button which copies this cell over to sheet2.
this is the code:
Sheets("sheet1").Range("A2:D7").Copy Destination:=Sheets("sheet2").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)
The function in Sheet1 causes a "REF" error, so can I add anything to the copy function to convert to text?

thanks