printing formulas in adjacent cells

You could try going to you formula row and highlighting it. YOu can then find the equal sign and replace it with '=.
Now copy and paste this row where you want to show them. Now, go back to first column and find '= and replace with a =.
who knows, it may work!

Good luck

IML, Thanks your instructions work however I was looking for more of a stream-lined approach. Like a function or formula that I could copy many times. I will keep trying...

CRaig

IML, Thanks your instructions work however I was looking for more of a stream-lined approach. Like a function or formula that I could copy many times. I will keep trying...

CRaig

You could try a UDF (User defined function)
eg.

Function sFormula(cell As Range) As String
Dim F
Application.Volatile
If cell.HasFormula = True Then
F = cell.Formula
sFormula = F
End If
End Function

Place this code into a module.
Then in cell D2 put in;
=sFormula(B2)
copy down as needed.

Ivan