View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alain Turgeon Alain Turgeon is offline
external usenet poster
 
Posts: 2
Default Error number 1004

Hi to everybody,

I use the line below to select data for creating a chart:

ActiveChart.SetSourceData Source:=Sheets("résultats").Range
(Cells(1, 1), Cells(k + 1, i + 1)), _
PlotBy:=xlRows

I have the error number 1004 when I execute this line. I
know that I can not use Cells inside a Range procedure but
how can I select a range of cells in some other way?

Thanks for the help!