| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear a range of cells given 2 Cell addresses
Hi
I want to be a able to clear a rectangular area. I know the top most left corner address. I know the bottom righ corner address. all addresses are in the format r,c where r,c are integers. So I know cell 1 to have coordinates (r1,c1) and cell 2 to have coordinates (r2,c2). How can I issue a clear command to clear all data and formulas in this region? Thanks much in advance. Ekareem |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| RANGE addresses. Getting from other cells. | Excel Worksheet Functions | |||
| If range is empty, clear other cells | Excel Programming | |||
| clear range of cells if another becomes blank | Excel Worksheet Functions | |||
| Clear range of cells in different worksheet | Excel Programming | |||
| Named Range Cells vs. Absolute Cell Addresses | Excel Programming | |||
Threaded Mode
