I have am writing a code, but I would like the code to read the value in the cell.
For Example, instead of putting 3 in "ActiveChart.SeriesCollection(1).Points("3").Select" I would like to put the value 3 in a cell, A1=3.
Here is my current code.
Sub MarkerPlacementAndColor()
'
' MarkerPlacementAndColor Macro
'
'
ActiveSheet.ChartObjects("chart 23").Activate
ActiveChart.SeriesCollection(1).Select
ActiveChart.SeriesCollection(1).Points("3").Select
With Selection
.MarkerStyle = -4142
End With
Selection.MarkerStyle = 1
Selection.MarkerSize = 10
With Selection.Format.Fill
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorAccent1
.ForeColor.TintAndShade = 0
.Solid
End With
With Selection.Format.Fill
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorText1
.ForeColor.TintAndShade = 0
.Transparency = 0
.ForeColor.RGB = RGB(0, 0, 0)
End With
Selection.Format.Line.Visible = msoTrue
Thanks,
Ehizzle
Bookmarks