Code does not work on merged cells

F

fuzzyfreak

My apologies if my post wasn't too clear, let me try to explain again -


Throughout my spreadsheet I have cells with Data Validation where you
select from a drop down list. These cells are then "Merged and
Centered" with the cell immediately to its right - so cell B3 is merged
and centered with C3. In my code, if I add B3 - the code doesn't work.

I have tried B3:C3 and even tried naming the cell and using the name.

Thanks
 
Top