Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
excel macro do-loop
Name: marek Date: September 30, 2003 at 06:46:48 Pacific OS: 2000 CPU/Ram: 1000/256
Comment:
My problem is that I would like to make charts in 'do loop' command but I don't know how to insert do-parameter in sheet series. Exactly how to insert in lines "=Sheet1!R3C2:R10C2" and "=Sheet1!R3C3:R10C3" changeable parameters (e.g. I and J) instead of numbers 2 and 3? the macro is below thanks for your help!
Sub Macro1() ' ' Macro1 Macro ' Macro recorded 9/30/2003 by nhw2zot '
' Charts.Add ActiveChart.ChartType = xlXYScatterSmooth ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("N33") ActiveChart.SeriesCollection.NewSeries ActiveChart.SeriesCollection(1).XValues = "=Sheet1!R3C2:R10C2" ActiveChart.SeriesCollection(1).Values = "=Sheet1!R3C3:R10C3" ActiveChart.Location Where:=xlLocationAsObject, Name:="Sheet1" With ActiveChart .HasTitle = True .ChartTitle.Characters.Text = "ADF" .Axes(xlCategory, xlPrimary).HasTitle = True .Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = "ADFFFF" .Axes(xlValue, xlPrimary).HasTitle = True .Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "ADFAE" End With End Sub
Summary: I don't think a macro in Excel will do the job. What you need is a simple program to iteratively go through the list of numbers and add them until you get the desired total, in which case you have a '...
Summary: Hello there, ok, i have made an excel macro which when someone selects a option from a drop down menu, output is generated accordingly.. problem is that i do not want people to view or pdify the macr...
