The below code works well (If I use activesheet), however there are many tabs in the workbook. If a user is on another worksheet besides the ("Pricing") sheet vba bombs on the line in red.
How can I ask the code to execute on line when I haven't even assigned a name (which is directly under...