How to get the value of a merged cell?

Question

I am working on a project that is supposed to make a pdf report from several Excel files. The files should look like this: http://img194.imageshack.us/i/24766860.jpg/ , and the pdf format should look like this: http://img96.imageshack.us/i/u2ntitled.jpg/ , where is the column location must have the value of the merged cell in the excel file (B2: E2).

So the difficulty is how to read the merged cell and put its value in the location column.

If this information is not enough, I can add the source code. If you want any other information to be asked, I will give it right away.

Answer 1

Merged cells in excel are read at their first cell address. You should be able to assemble a merged cell B2: E2 as B2