What is the selection syntax
Sure, that is what currentregion is all about. But
In contrast, if row 7 is blank, then it doesn't.
but
set rng1 = Sheet1.Range("A8").CurrentRegion
sheet1.Range("A8",rng1(rng1.count)).Clear
or if the data isn't contiguous
set rng1 = Sheet1.UserRange
sheet1.Range("A8"),rng1(rng1.count)).Clear
or
With Worksheets("Sheet1")
.Range(.Cells(8,1),.cells(rows.count,columns.count )).EntireRow.Clear
End With
--
Regards,
Tom Ogilvy
"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
|