Im trying to set a chart to a varible, however since I have multiple charts in my spreadsheet I need to be able to activate a chart and assign it to a varible.

Ffor the record `ChartHandel = ActiveSheet.ChartObject(1)` doesn't work,I have also tried `.Shape(1)` and `Chart("Name of chart")` and these too dont work

```
Dim ChartHandel2 As Chart

ActiveSheet.ChartObjects(1).Activate
ChartHandel2 = ActiveChart

```

Even this gets error '91, Object Variable or with block varible not set' which it looks like it should work and I was sure I had had this working at one point(as a workaround)

My question is basicly can you assign a chart to a varible if it isnt active (and if possible how)?