Hi,

I have 6 cells in a row. I have merged them in groups of 3, to form 2
largers cells. The cells a

H1 and K1

H1 is the merger of H1, I1, J1
K1 is the merger of K1, L1, N1

Now i want to use the Offset function to refer to K1 from H1.

I tried

Range("H1").offset(0,1)
and also
Range("H1").offset(0,3)

but both didn't get me to K1.

Its soemthing to do with Merged Cells and the Offset Function I think.

Any ideas?


---
Message posted from http://www.ExcelForum.com/