| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Location of Cell with Value in Merge Area
If I have a range object consisting of only a single mergedarea in VBA and
want to determine which cell is the one holding the value, how can I do that? Two examples: Merged Range is A1:D7 Value is in A1 Merged Range is A1:D7 Value is i n D7 [I believe that the value of a merged range can only be in the upper right cell or the lower left cell. The above examples are for illustration only.] In a general sense, how can I determine the location of the cell with the value? Note: I won't know in advance whether the cell with the value is populated or blank. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
| How to shift the cell based on the location of other cell? | Excel Programming | |||
| automatic offset cell location when there is a value in a selected cell. | Excel Worksheet Functions | |||
| How to merge all selected areas into one area | Excel Programming | |||
| only last cell on page to have bottom border (cell area outline) | Excel Worksheet Functions | |||
Threaded Mode
