Hello,
In the attached spreadsheet:
E1 is working as desired.
E1 was copied down to give E2.
But, because there is no value in D3, what it shows is #VALUE!
This is because D3 contains a text string, and so arithmetic cannot be done on it.
Anyone know how overcome this with VBA?
Bookmarks