Need to multiply my discount amount by -1

I am using MS Excel 2021 Mac.
I am using some VBA code that works just fine.
I copied the logic that inserts the "Tips" amount for a sales transaction to also insert a new row if there is a discount amount. See block "Insert discount row".
The discount amount is in column K as a negative number.

here is my code

Please Login or Register  to view this content.

I get an error on this line where I want to multiply the discount amount by -1.
Union(.Columns("J"), .Columns("L"), .Columns("AE")).Value = .Parent.Range(("K" & i) * -1)

The discount amount in the excel has to be a positive number, as it is converted to a negative amount when I import it into Quickbooks.

What am I doing wrong?

Try this:

Please Login or Register  to view this content.

You're welcome.



If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.