Posts by Elaine

    Hi,


    I'm about ready to tear my hair out.
    Have a WS named Charts and in it is a dual y axis graph.
    It used to work fine but the test data has now been moved to another WS.
    I've tried recording macros by Rt clicking on graph, selecting source data, and redefining the x & y values for both series.
    The macro doesn't work, I keep getting:
    "Unable to set the XValues property of the Series class"


    Here is the code:


    Windows(File).Activate
    Sheets("Charts").Select
    ActiveSheet.ChartObjects("Chart 1").Activate
    ActiveChart.ChartArea.Select
    ActiveChart.SeriesCollection(1).XValues = "=Sheet1!R9C11:R11C11"
    ActiveChart.SeriesCollection(1).Values = "=Sheet1!R9C20:R11C20"
    ActiveChart.SeriesCollection(2).XValues = "=Sheet1!R9C11:R11C11"
    ActiveChart.SeriesCollection(2).Values = "=Sheet1!R9C12:R11C12"
    Windows(File).SmallScroll Down:=0
    ActiveWindow.Visible = False
    Windows(File).Activate
    Range("L31").Select


    Thanks for your help in advance!
    Elaine

    Hi,
    I have two workbooks with a variable number of worksheets in each.
    I want to copy workbook 1 into workbook 2 (consolidating two workbooks into one, but keeping all worksheets independent).


    Thanks in advance for your help!

    Is there a way to include a path (S:\A\B\C\D) in GetOpenFilename so users don't have to work their way down to the appropriate directory to select a file?


    Thanks in advance for your help.
    Elaine