Information générale
Catégorie:
COM/DCOM et OLE Automation
>Thanks, Sergey !
>
>I did not realise that the macro I was using had worksheet protection code incorporated, which was giving me errors. Afer your code initially did not work, I gave it an all-new scrutiny, and traced this problem.
>
>I used your second formula, and I am getting the result of the formula in the cell, but not the formula itself.Any way I can get the formula in the cell? Thanks !
>
Don't set the Value property. Instead, set the Formula property of the cell.
Tamar
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement