The following code doesn't work for me. The code seems to fail on the last line. Do I have the correct syntax for inserting a photo in to a worksheet? The name of the photo should match the ANACode.
Sub Photo_Selector_Change()
Dim IA As Workbook:
Dim ES As Worksheet
Dim InputSheet As Worksheet...