Originally Posted by
SteveG1965
Hi John,
Thanks for revisiting. L24 (Sheet8) is copying across to Column C (Sheet11) where the date in Column B (Sheet11) = F1 (Sheet8), but the value does not become static. Meaning, every time a new date is chosen in F1 (Sheet8), the previously updated cell in Column C (Sheet11) reverts back to zero, so that cell has not become static. Someone has suggested that what I'm trying to achieve, simply can't be done is that right?
PS: Still getting Run-Time Error '9':
Subscript out of Range
Maybe try
I can't duplicate the run time error. Based on the sample you provided, it works when tested.
Bookmarks