Referencing a Name from within VBA

[cmazur71]

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")

 

[Cbrine]

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")

This should do it.
Set AMOUNT = Worksheets("Quote").range("DISCOUNT")