Posted 8 September 2017, 2:06 pm EST
I added the below line of code to get the totals row in my spread and it works fine. In the columns that are text, it shows a zero. I want to show blank cell in the place of a zero. I tried to wrap a IF function around the sum but was not successful. How can I achieve this ?
fpspread1.ActiveSheet.Rows(fpspread1.ActiveSheet.Rows.Count - 1).Formula ="SUM(A1:A" & fpspread1.ActiveSheet.Rows.Count - 1 & ")"