hi
i have this how can insert this line
into this line of code:
thank you
i have this how can insert this line
Code:
$ " & Format(Range[B][COLOR=#b22222]("b9").Value, [/COLOR][/B]"$#,##0.00;($#,##0.00)")
into this line of code:
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" & "," & " $ " & [COLOR=#b22222][B]ThisWorkbook.Sheets("Icube").Range("B9").Value[/B][/COLOR]
thank you