actually, I am new to excel vba, can you give some more hint about
"assigning a Defined Name to the price column"

do you mean use a variable as the name of the column variable? is it
possible in excel vba?

Thank you very much

Gary''s Student wrote:
For the second problem, consider assigning a Defined Name to the price
column. That way, if you add/remove columns, your code can track the price
column automatically.