Here to help and learn. Apologies if sometimes I fail at the former.

Dupe links:

• Avoid using Select
• Find last cell
• Vlookup, 2 columns
• Use Long, not Integer
• Getting range from inactive sheet
• Range(Cells, Cells)
• Double quotes in a string
• Highlight words from list
• Formulas and Language
• Textjoin UDF
• Insert variable in formula
• Use Union when deleting
• Test if Find succeeded
• VLOOKUP where key is not in first column
• Last row in a table
• Add DA formula

Quick Reference Links:

• Reproducible pandas examples