Application.Intersect code

[Yvonne Love]

I recently watched Chandoo's master class "All Versions of the Truth", and I have recreated his dashboard step by step with my own data, but I am having issues with some of the VBA code. I have copied his code verbatim (changing named ranges if needed, and even renaming my ranges to the same as his) but I get debugging errors and I can't figure out at all what I am missing. I think I've even checked my spelling several times and thoroughly so I really hope it isn't something like that.

Any ideas on what is wrong with my code?

I've attached the file for reference.

Thank you!
Yvonne

 

[Chihiro]

I think you have Worksheet_Selection change code in wrong worksheet.
Since named range is referring to Output sheet, you'd need the code there.

Also, displaychart sub will need to be in either Module1 or Module2 (standard module and not in workbook or worksheet module).

Edit: updated workbook attached with changes mentioned above.

 

[Yvonne Love]

Great, thanks so much. I know lots about excel and am just now delving into VBA. Thank you!