Because I use VBA for just about everything,
my approach is a bit more involved...
What I would suggest is to create a Worksheet_Change event:
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Dim I, Col_Name, Col_Pin
Col_Name = 1 'Column to monitor for content
Col_
Hi Grunta,
The result will change every time you do an activity in excel like. typing
in data, or inserting rows / columns etc. Best way to avoid it would be
do copy -> paste - > special -> values on the cells / numbers which are used
up.
Further to this, if you want that the data which is used
Hi Grunta,
This can't be done with worksheet formulas, as they will be re-calculated
everytime something changes, as you have discovered.
You will need to use the RND function in VBA to put a value in a cell. Since
this is done only once, the value won't change when the sheet re-calcs.
Regard
