MS VBA/Excel

[whocares]

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.

 

[Kwyjibo]

I've never had much luck taking my VBA between office and office v.x ... i took a class in VBA/excel and I used VPC just to make everything easier on me ... It was slow but i had to ensure compatiblity to pass the class.

I wish i could help you with your problem