I have a workbook that imports data with PI datalink, however sometimes we get I/O timeout or #value this effects all the formulas we have in the sheet such as average
Would it be possible to use averageif function if we have I/O timeout or #value errors for the following code?
Range("I7").Value = "=average(G4:G" & lastrow & ")"
I tired to add it to average values above zero however it didnt work
Range("I7").Value = "=averageif(G4:G" & lastrow & ",>0)"