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 |
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 |
All times are GMT +1. The time now is 11:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com