vba chart creation on a new worksheet

  • I'm having problems with a spreadsheet trying to create a new spreadsheet and then creating a new chart. I seems to have corrupted the code but I can't figure out what has happened. (i performed the ultimate crime and saved over my original code) doh!!!!!!!!


    Any help would be gratefully appreciated.


  • Re: vba chart creation on a new worksheet


    Hi Giorgio,


    The code now generates a chart. I have included comments where I have changed the code.


  • Re: vba chart creation on a new worksheet


    Thanks I feel as if a bus has run me over, can't imagine what was going on in my head to screw this macro up so badly in such a little amount of time. I will be eternally grateful for your help....


    p.s. did I say it works. many thanks

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!