Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is the selection syntax
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limiting selection in a cell AND linking that selection to a list | Excel Discussion (Misc queries) | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
syntax for range selection | Excel Programming | |||
Object Type of a selection... counting rows in a selection | Excel Programming | |||
Syntax - Add Range Name based on Selection | Excel Programming |