LordGarsdale
IS-IT--Management
Hi all
I have a large spreadsheet with lots of formulae scattered around on it.
Is there any existing program (VB or VBA ?) that will just print out a list of cells that have a formula in and the formula.
I have tried the 'old' method of formula - view - print but due to formula lengths, I needed to make all of the columns very, very wide and the hardcopy was almost impossible to read.
Here's hoping otherwise guess what I'll be doing over the Christmas break :-(
John
I have a large spreadsheet with lots of formulae scattered around on it.
Is there any existing program (VB or VBA ?) that will just print out a list of cells that have a formula in and the formula.
I have tried the 'old' method of formula - view - print but due to formula lengths, I needed to make all of the columns very, very wide and the hardcopy was almost impossible to read.
Here's hoping otherwise guess what I'll be doing over the Christmas break :-(
John