Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
formula to determine if cell is merged?
Is there any simple or creative formula (not macro or user defined
function) that I can use to determine if a given cell reference (e.g., cell C133) is part of a merged range? Maybe use some kind of function that won't work on cells that are part of a merged range could give me a known error that I could use as my indicator? Craig in NJ |
#2
|
|||
|
|||
Craig,
Nope. You are limited to using VBA, either through a UDF or a macro. HTH, Bernie MS Excel MVP "CraiginNJ" wrote in message oups.com... Is there any simple or creative formula (not macro or user defined function) that I can use to determine if a given cell reference (e.g., cell C133) is part of a merged range? Maybe use some kind of function that won't work on cells that are part of a merged range could give me a known error that I could use as my indicator? Craig in NJ |
#3
|
|||
|
|||
I appreciate and respect your fast answer, Bernie, but before I give up
I'd like to ask: Are there any functions that won't work with merged cells? Maybe something to do with array math (i.e., ones entered with Ctrl-Shift-Enter)? Anything else? Craig |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
up to 7 functions? | Excel Worksheet Functions | |||
Function to determine if any cell in a range is contained in a given cell | Excel Worksheet Functions | |||
How can I write an if-then formula for 0 or less than 0 in cell t. | Excel Worksheet Functions | |||
How do I do math on a cell name in formula? | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |