Currency format email Subject line

[josros60]

Hi i have this code for subject line of email

works fine but once i put the number format shows the word "false" in the subject line,

here is the code:

EmailSubject = "TNW a/c " & " " & ActiveSheet.Range("A3") & "," & " " & "Statement Of Account $ " & [COLOR=#ff0000][B]ActiveSheet.Range("I1").NumberFormat = "$#,##0.00_);($#,##0.00)"[/B][/COLOR]

how can i fix that?



thank you

 

[FormR]

Hi, try like this instead:

EmailSubject = "TNW a/c " & " " & Range("A3") & "," & " " & "Statement Of Account $ " & Format(Range("I1").Value, "$#,##0.00;($#,##0.00)")

 

[josros60]

thanks so much worked perfectly.

 

[josros60]

sorry, i have one more question,

how can i use this

$ " & Format(Range("b9").Value, "$#,##0.00;($#,##0.00)")

in this code:

                strsub = "TNW a/c #" & " " & ThisWorkbook.Sheets("Icube").Range("A7").Value & " " & "and" & " " & " " & ThisWorkbook.Sheets("Icube").Range("A8").Value & ", " & "Credit Card charges authorization for the " & ThisWorkbook.Sheets("Icube").Range("J2").Value & " " & "Invoices" & "," & " $ " & ThisWorkbook.Sheets("Icube").Range("B9").Value

thanks again

 

[FormR]

Hi, your new question is not clear to me?