Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Range of Cells
I'm trying to write a macro that will select a certain range of cells. The
problem is, new rows will be added to and subtracted from the worksheet. But i still want to be able to have this macro select a certain range, all in one column and then clear the contents of that range. Also, I have cells throughout the sheet that are grouped and span the length of the sheet. These cells have text in them, and that text is constant, will not change and are group headings. I'm guessing I have to have the macro select the cells in the specified row between two constants, then clear the contents and then go on to the next section. I'm just not completely sure how to do that. I'm new to VBA and have some VB experience. I understand some of the constants. Thanks I hope I'm not asking too much. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting a range of cells , how to ? | Excel Programming | |||
Range selecting cells | Excel Discussion (Misc queries) | |||
selecting a range of cells | Excel Programming | |||
Selecting a Range of cells in VBA | Excel Programming | |||
Selecting a range of cells | Excel Programming |