Hi,

thanks very much for the details... it solved the problem. However it
raised one more query now setting up a particular column(entire column alone)
as a range to Range object's range property. Has any clue.

thanks,
-Ram.

"jlepack" wrote:


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.