View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
curlydave curlydave is offline
external usenet poster
 
Posts: 206
Default Macro for displaying formula

Another option would be to place the formulas in the Cell Comments
using vba...

With Range("B20")

.ClearComments
.AddComment
.Comment.Visible = False
.Comment.Text Text:=Range("B20").Formula
.Comment.Shape.TextFrame.AutoSize = True

End With