What is the selection syntax
this is one way
Sub test()
With Sheet1.Range("a8", ActiveCell.SpecialCells(xlLastCell))
.Clear
End With
End Sub
--
Gary
"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
|