View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Beto[_2_] Beto[_2_] is offline
external usenet poster
 
Posts: 6
Default Getting the formula of a cell as text

Thanks to all who answered. I'll try the solutions soon!

Regards,
--
Beto

"Peter Atherton" wrote in message ...
Hello Beto

A similar solution to Tom's is:

Sub MyIndirect()
Dim Cell As Range
Dim s As String
If ActiveCell.HasFormula = False Then
MsgBox "There is no formula in this cell", , "Error_
Alert"
Exit Sub
Else: s = "" & ActiveCell.Formula & ""
Range(s).Select
End If
End Sub