CheckSpelling on Merged Cells

**snapfade** · 03-01-2014, 01:10 PM

Hi,

I have a worksheet with merged cells (Yeah, I know...no choice). I need to check spelling on merged cells that are 29 columns wide.

I cannot seem to get this code right. Any suggestions would be appreciated.

Please Login or Register  to view this content.

Thanks!

**Norie** · 03-01-2014, 01:13 PM

Where are the merged cells located?

**snapfade** · 03-03-2014, 06:31 PM

Hi Norie,
The merged cells are located in column J, Sheet1 of the ActiveWorksheet. Sorry for the delay...was our for the weekend. Thanks for your help.

**Norie** · 03-03-2014, 07:24 PM

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

**snapfade** · 03-03-2014, 07:55 PM

Attached as requested. The target cells are always 29 columns wide. There are other merged cells on the worksheet too but the code I have so far can check for the width of 29 and skip cells of differernt widths. The target cells are always located at Column J. As demonstrated by the empty rows, these merged cells appear on some rows but not others. there is no pattern of when they show up except that there will be always one or more at any place where the merged cells appear.

Hope this helps.

Thanks again.