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

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

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