The file from on how to insert a picture into a excel page from a "named path" is great. I could make real use of this but would want the picture to go on the report sheet, vs the menu sheet where the "week" is being selected. The files is at.... http://www.contextures.com/excelfilesRon.html
I have tried moving the named range for the picture to another sheet, but it errors out. Can this be done with this routine.

Tom