Referencing Cell

[sonicbug]

Hi,

I am working with a worksheet that has some cells merged e.g. A1 and A2 are merged together as 1 cell. I am using cell offset to reference values from the worksheet assign them to variables then populate another worksheet with their respective values. I noticed that cell.offset(row,column).value is not retrieving a value when merged cells are mixed with non-merged cells within a given row. Is there another method/function I can take advantage of here?

Any suggestions are welcomed and appreciated.

Thanks in advance,
Michael

[zbor]

Suggestion 1: Don't use merged cells
Suggestion 2: Try work with

Please Login or Register  to view this content.