| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to tell whether any cell within a Range has non-empty contents
I am writing a VSTO addin for Excel 2003 that reads data from a
database and populates a range of cells. I want to be able to detect if there is any existing data within any of the cells in the range, so that I can prompt the user whether to overwrite or insert rows/ columns. The amount of data returned could be different each time. Is there a method that will tell me if any cell in a range is occupied (including a formula), and which cell it is within the range? Thanks for the help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cell contents in empty rows below it till any unempty row com | Excel Discussion (Misc queries) | |||
| Macro to clear range contents when cell contents are changed by us | Excel Programming | |||
| How do I set one cell to equal another if its contents are empty? | Excel Worksheet Functions | |||
| Finding next empty empty cell in a range of columns | Excel Programming | |||
| Filling empty cells with contents from another cell | Excel Programming | |||
Threaded Mode
