PDA

View Full Version : select all range



fraser5002
01-05-2009, 08:17 AM
Hi how do i select the entire spreadsheet as my range

i.e

range("all:all").select

JimmyTheHand
01-05-2009, 08:24 AM
Activesheet.Cells.Select

xld
01-05-2009, 08:41 AM
Activesheet.UsedRange.Select

fraser5002
01-05-2009, 08:44 AM
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
01-05-2009, 08:56 AM
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

xld
01-05-2009, 09:00 AM
ActiveChart.SetSourceData Source:=Worksheets("sheet1").Cells, PlotBy:=xlColumns

Kenneth Hobs
01-05-2009, 09:05 AM
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