I have a Name (DISCOUNT) defined in my workbook. (DISCOUNT refers to cell A20)
How can I reference that Name from within VBA?
This code works, but DISCOUNT may not always reference A2. I may insert additional rows.
Set AMOUNT = Worksheets("Quote").range("A20")
How can I reference that Name from within VBA?
This code works, but DISCOUNT may not always reference A2. I may insert additional rows.
Set AMOUNT = Worksheets("Quote").range("A20")