I don't want the formulas to show, just the resultant constants please and thnx
Use Bakerman2's code in post 13. You can delete the Worksheet_Change event procedure.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Bookmarks