I'm in a tight spot right now... A could do with a VBA cool trick! I have about 150 Excel sheets in various files with 1 graph per sheet. Somehow all the references for the graphs are screwed up (sheet name is replaced by a pesky #REF). I've taken a look at the VBA help files and they're uncomprehensible. I could really do with a macro to replace the '#REF' with the name of the active sheet, but I just can't figure it out. Any help most appreciated! cheers, D.