I have an application that reads data from tables in excel. The tables have entries which usually take up one line, then the next line is blank and merged across the table, so in order to get to the next entry I advance 2 rows.

The problem arises when entries take up two rows. In this case advancing 2 rows brings you to a blank, merged row. What I want to do is after advancing two rows, determine if that row is merged and if it is advance another row. Is there a way to determine if a certain cell address is part of a larger merged cell?

Thanks,
--Rikki