Merged Cell Check

  • Thread starter Thread starter mark_hall
  • Start date Start date
M

mark_hall

Hi,

I currently have a series of merged cells which I want to be checked
for population before allowing the user to the send the s/sheet off.
I'm currently using :

For Each Name In Range("mandatory_fields")
If Name.Value = "" Then
etc....

However, say for example i have a merged cell of h12:o12 called
"mandatory_fields". The macro counts them as individual cells so even
when populated, it can never be validated - wants cell I12 to be
populated etc...

This make sense to anyone?
 
You can't. Take a good advice and unmerge the cells, you are only make
things difficult
using merged cells. If it is looks you are after you can achieve that with
workarounds.
I have never heard anything good about merging cells. Pertaining your
question, once you merge cells
tall except the leftmost are basically gone so you cannot do anything in
your case with I12
 
What options are available then.

I know about control textboxes but i'm not to sure how to use them or
if it is a bit of overkill.
 
Mark
Do this to demonstrate how to get the "merged" effect without merging:
Type your name in A1. Hit Enter.
Select A1:A7
Click on Format - Cells - Alignment tab. In the "Horizontal" box, select
"Center across selection". Click OK.
HTH Otto
 
Back
Top