Setting Cell Vaules Without Overwriting the Formula?

  • Thread starter Thread starter Aanika
  • Start date Start date
A

Aanika

Hello,

Please could you advise me how I can set cells to certain
vaules without overwriting the existing formulas?

I had tried to use the following in a VBA User Defined
Function, but which does overwrite the formula in the
cell:

Cells(RowNo,ColNo).Calculate = NewValue

I am grateful for any help

Thanks

Aanika
 
See reply in programming. If you want to post to multiple groups, it is best
to post to them all in one message.
 
Back
Top