Good morning community,
As a novice VBA programmer I was fortunate enough to discover quickly enough for my project that the correct way to clear/reset cells which are calculated in a formula is not to set the value, ie:
Range.Value = ""
Do not do this if cell is referenced in a formula...