select all range

[fraser5002]

Hi how do i select the entire spreadsheet as my range

i.e

range("all:all").select

[JimmyTheHand]

Activesheet.Cells.Select

[Bob Phillips]

Activesheet.UsedRange.Select

[fraser5002]

hmm its not working.

what im trying to do is select all the cells then create a sctatter graph from them


activechart.setsourcedata source:=("sheet1").range(cells.select), plotby :=xlcolumns
this is giving me an error, how do i go about this?

[Artik]

You try withRange("A1").CurrentRegion if data starts in A1.

And read once more
The more details you give, the easier it is to understand your question. Don't save the effort, tell us twice rather than not at all. The amount of info you give strongly influences the quality of answer, and also how fast you get it.
Artik

[Bob Phillips]

ActiveChart.SetSourceData Source:=Worksheets("sheet1").Cells, PlotBy:=xlColumns

[Kenneth Hobs]

When asking a question, state the goal, not the path you think it needs to meet the goal. In this case, Select is a red herring.

Try:
ActiveChart.SetSourceData Source:=Worksheets("sheet1").UsedRange, PlotBy:=xlColumns