LinkBack URL
About LinkBacks
Maybe like this :
and
ActiveCell.FormulaR1C1 = _ "=UPPER(TEXT(INDEX(Sheets(" & myValue & ")!C[-2],COUNTA(Sheets(" & myValue & ")!C[-2]),1),""mmmm d, yyyy""))"
ActiveChart.SeriesCollection(1).XValues = "=Sheets(" & myValue & ")!B2:B500"
Maybe like this :
andActiveCell.FormulaR1C1 = _ "=UPPER(TEXT(INDEX(Sheets(" & myValue & ")!C[-2],COUNTA(Sheets(" & myValue & ")!C[-2]),1),""mmmm d, yyyy""))"
ActiveChart.SeriesCollection(1).XValues = "=Sheets(" & myValue & ")!B2:B500"
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks