Chart macro needs modification

**ant1905** · 03-08-2013, 07:53 PM

Hi all,
I recorded the following macro and assigned it to a button and it works but I need to find the right syntax instead of James! in the code. After couple hours of web searching
I ended up with no clue whatsoever since I have next to none knowledge of VBA. What I want to do is to replace James! with something like ActiveSheet! ( I suppose).
Code is as follows:

Please Login or Register  to view this content.

Any help or directing is most appreciated. Thanks in advance

**ant1905** · 03-08-2013, 10:01 PM

ahh

depressing ... no replies ... solution must be harder than I imagined

**coreytroy** · 03-09-2013, 02:47 AM

Have you tried

Please Login or Register  to view this content.

Assuming the sheet is 1 that is.

**ant1905** · 03-09-2013, 06:20 AM

Hi Corey

Actually I have around 50 worksheets in that one workbook.. and loads of charts in every sheet , so insted of defining every other sheetname I m trying to figure out this macro solution and keep it compact.

**Andy Pope** · 03-09-2013, 06:24 AM

Please Login or Register  to view this content.

**ant1905** · 03-09-2013, 06:29 AM

Worked like a charm
Thanks alot Andy Pope... sincerely, most appreciated.

Chart macro needs modification

LinkBack

Thread Tools

Rate This Thread

Display

Chart macro needs modification

Re: Chart macro needs modification

Re: Chart macro needs modification

Re: Chart macro needs modification

Re: Chart macro needs modification

Re: Chart macro needs modification

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions