I need some help with the following.
My spreadsheet produce a calculation in column C such as C1 = A1/B1
First question how to copy that formula down all the way to C100. ( I was able to do it using a loop but it must be a better way)
For i = 1 To 100
w.Worksheets(0).Cells("C" & i).Formula = "=A" & i & "/" & "B" & i
Second question is :
some of the division will yield the error #DIV/0!
I need to loop from C1 to C100 and find cells with #DIV/0! and replace with ""
How can I use aspose cells Findoptions or ReplaceOptions to achieve this search and replace operation?