Hi!
I use VBA to update the information of a workbook into an other. I would
like to copy and paste the formula regarding to :
A) It is an external link.
B) The link is valid (can I test it without displaying a pop-up box which
ask to select a new file?)
C) The value of the link is equal to the value of the cell (Could differ if
the link was not updated in the other workbook.)
So, the formulas should be copy only if A, B and C is True. If not, I would
like to copy only the value of the cell.
Is there a way to achieve that?
Thanks a lot ;)