All,
Another head scratcher for me..
So this is what I'm trying to do, if B3 is merged return Yes in L3 and if it isn't return No, then move on to B4 and return the answer in L4 and so on..
Thanks :D
All,
Another head scratcher for me..
So this is what I'm trying to do, if B3 is merged return Yes in L3 and if it isn't return No, then move on to B4 and return the answer in L4 and so on..
Thanks :D
Hi amoxia,
Try this:
Regards,Please Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
You might use this UDF
and the formula =IF(IsMerged(B3), "Yes", "No") in L3Please Login or Register to view this content.
But it would be best to avoid merged cells altogether. CenterAcrossSelection is much more friendly (to the developer) than merged cells.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Thanks guys - Trebor worked awesomely!
Yes I would love to avoid merge cells but the boss wants what the boss wants! thanks again!!
Thanks for the feedback and you're welcomeThanks guys - Trebor worked awesomely!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks