Jon, thanks for response, but the formula is OK. When i set breakpoints in MS
office Visual Basic editor the code stop at the breakpoint and when i resume
everything works well.

I send U on your email the whole code if that should help.

Henrich

"Jon Peltier" wrote:

Assuming von is a letter and number combination and bis is just a letter:

ActiveChart.SetSourceData Source:=Sheets("DATEN").Range(von & ":" & bis &
"1,A1:A11"), PlotBy:=xlRows

I would assume that this is fraught with errors in normal usage. Are your
variables somehow typed in? Do you have any validation?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Henrich" wrote in message
...
Hi,

i'm using this to change chart like this:

ActiveChart.SetSourceData Source:=Sheets("DATEN").Range("" & von & ":" &
bis
& "1,A1:A11"), PlotBy:=xlRows

where von and bis are given by user from inputbox
it was working but than it gives me an error 1004. why?

Thanks
Henrich