If you mean all the cells in a worksheet and not the entire worksheet
itself then

public sub selectAllCells()
dim r as range
set r = cells
r.select
end sub

but if you just want to select all the cells from the sheet to
copy/paste/delete/whatever then:

cells.select

is your best friend.

Cheers,
JAson Lepack



Rp007 wrote:
Hi,

How do we set the entire Excel worksheet as a range to the Excel Range
object's range property? I know we can set a particular column or from one
cell to another cell as a range to Excel Range object's range property but
how to set the entire worksheet as a range.

Any ideas, please share.

thanks in advance,
-Ram.