Results 1 to 4 of 4

Make Macro run on more than 1 chart sheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-20-2007
    MS-Off Ver
    2003 & 2007
    Posts
    299

    Make Macro run on more than 1 chart sheet

    I am using the following code to update a chart. It works, but I would like to know a good way of making it run on mulitple chart sheets without having to repeat the code over and over. Maybe using the select case command? I don't know how.

    Public Sub ChangeAxisScales()
        With Sheets("Chart3")
                .Axes(xlCategory).MinimumScale = Range("startdate").Value
                .Axes(xlCategory).MaximumScale = Range("endate").Value
            End With
    End Sub
    Last edited by erock24; 01-18-2009 at 01:32 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1