Get item from merge cells

I can’t seem to get row item in an excel range due to merged cells. How can I split/unmerge the cells?

BalaReva.Excel.Activities Unmerge Cells in an Excel - #3 by balupad14

1 Like

Hello @aretotaco , By using Macro VBA code you can unmerge cells. Refer to this thread it may helps you.

Hi @aretotaco

You will get the value of merged cell but the value when read would be present in the first cell from
Where it was merged

Say cells A1,B1,C1 are merged then when you read value wpuld be present in A1 related cel item and remaining will be empty