For auditing purposes i want to be able to view all the formulas in a
selected range. I can use the Tools/Options menu where I do a View Formulas
but this is used for the entire sheet and I'm only interested in a selected
range.

I have also reformatted the range by code using: cell.value = "'" &
cell.formula which works fine, but I cannot seem to revert the process.

Does anybody have an idea to how I can display formulas in a selected range
in a nice way?

Thank you
The Doctor