MS VBA/Excel

Discussion in 'Mac Apps and Mac App Store' started by whocares, Jan 17, 2004.

  1. whocares macrumors 65816

    whocares

    Joined:
    Oct 9, 2002
    Location:
    :noitаɔo˩
    #1
    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.
     
  2. Kwyjibo macrumors 68040

    Kwyjibo

    Joined:
    Nov 5, 2002
    #2
    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
     

Share This Page