Yes it is. CurrentRegion region is the range bounded by any combination of
blank rows and blank columns (or spreadsheet edges), down, up, left and
right.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"GKeramidas" wrote in message
...
tom:

when i have values in a1 thru a15 and use your code, it deletes everything
in column a, not just a8:a15.

is this right?

--


Gary


"Tom Ogilvy" wrote in message
...
Sheet1.Range("A8").CurrentRegion.Clear

--
Regards,
Tom Ogilvy


"hon123456" wrote in message
ups.com...
Dear all,

I have the following sentence which select a range, and
then I want to clear the selected area.

Sheet1.Range("A8").Select
Sheet1.Range(Selection,
ActiveCell.SpecialCells(xlLastCell)).Select

Then I want to tell excel the clear the selected area? I
write the following sentence,but it is not
work.

Sheet1.range(selection).clear

What is the right syntax to point out a selection.

Is that something like that: sheet1.selection or
sheet1.range.selection ?

Thanks