I have some code that updates trendlines on a chart. The code runs fine if the sheet with the chart is active, but not if another sheet is active (which will be the case).
I get Type Mismatch on the highlighted line. Any ideas?
Sub Trendline_Update()Dim PVTrend As String
Dim EITrend As String...