VBA to sum cells with text

[Shadkng]

Hi, I am using the below line of code to build a filename based on the values in various cells. I would like to sum the value of cells B10 and B11, however there is a formula in B11 and when there is no value I am getting an error. I know that using SUM in a regular formula negates the #VALUE error when adding cells that have text. So my question is there a way to use the SUM function to add B10 & B11 in this line to avoid the error? Thanks for the help.

fileSaveName = "FRIEDLAND QUOTE " & [B7] & " " & "JOB " & [B8] & " " & [A30] & " " & [AB26] & " " & [COLOR=rgb(184, 49, 47)][B][B10+B11][/B][/COLOR] & " PCS" & " " & Format(Date, "mmddyy")

 

[Trebor76]

Hi Shadkng,

Assuming you're using Excel 2007 or higher just wrap the current formula in cell B11 with the IFERROR function to return zero if it errors out.

Robert

 

[Alex Blakenburg]

If you use the Sum function instead of "+" it will treat the text as zero.

fileSaveName = "FRIEDLAND QUOTE " & [B7] & " " & "JOB " & [B8] & " " & [A30] & " " & [AB26] & " " & _
                    Application.Sum([B10,B11]) & " PCS" & " " & Format(Date, "mmddyy")

 

[Shadkng]

If you use the Sum function instead of "+" it will treat the text as zero.

fileSaveName = "FRIEDLAND QUOTE " & [B7] & " " & "JOB " & [B8] & " " & [A30] & " " & [AB26] & " " & _
                    Application.Sum([B10,B11]) & " PCS" & " " & Format(Date, "mmddyy")

Hi Alex, sorry for the delay in replying. Your solution worked great! Much appreciated.
Thanks

 

[Alex Blakenburg]

Thanks for letting us know. Glad we could help.