Formatting query

  • Thread starter Thread starter Collias2003
  • Start date Start date
C

Collias2003

I have a spreadsheet that has a lot of formulae in it. Colleagues enter
a formula into one cell as part of the necessary calculation. This is
needed to be shown when printed. If I select view formulae in the
normal manner (through options) then all the formulae is shown whereas,
I just want the formula in the particular cell to be shown.

Any Ideas/ advice!!!!?
 
One way with a macro

Sub testing()
Dim cell As Range
With Sheets("Sheet1").Range("C5:E10")
For Each cell In .SpecialCells(xlCellTypeFormulas)
cell.Value = "'" & cell.Formula
Next
Sheets("Sheet1").PrintOut
..Value = .Value
End With
End Sub
 
Back
Top