I think he wants to only run the code once on opening the workbook, so that is why I recommended storing a value in a cell.
I think he wants to only run the code once on opening the workbook, so that is why I recommended storing a value in a cell.
Hope that helps.
Get the free Excel based Toolbar or click here for free examples & Excel Consultancy
RoyUK