Vbnet excel removing formula

Help Studio
, , ,
1

How to remove formula in excel using vbnet in uipath
column A Column B has values
calculating Column C, C=A*B
how to write code in vbnet and run in uipath

2

Try this. I have commented the code so that you will not have a problem understanding it. But if you still do then simply ask :slight_smile:

'~~> This will enter the formula in the entire range in one go
Range("C1:C6").Formula = "=A1*B1"
'~~> This will convert the formula to values
Range("C1:C6").Value = Range("C1:C6").Value