| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
twist on next empty cell
I've seen hundreds of ways to activate the next empty cell in a column, but
I need to activate a cell in column A one row down from the last entry in a range of cells ("A2:E32") to copy more data into. The problems I've run into stem from the fact that cells A33:E33 contain averages of the data in that range, so they are included in any xlUP or xlDown or UsedRange arguments. What I want is a single statement as opposed to a cell scan. -- David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| range, cell refrence, but with a new twist | Excel Worksheet Functions | |||
| Cell protection - with a twist | Excel Discussion (Misc queries) | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| Splitting a cell, with a twist! | Excel Discussion (Misc queries) | |||
| Empty cell and a the empty String | Excel Programming | |||
Threaded Mode
