offset from merged cells

[smiler44]

I have what I think is a merged cell covering columns A,B,C,D,E,F and G
I want to go down 3 rows and across 2 to column C
offset(3,2) goes down 3 and across but ends up in column I
offset(3,0) goes down 3
offset(3,-1) errors as there is no column to the left of column A

Am I right in thinking the "only" way is to
offset(3,0)
offset(0,2)

or should there be something in the brackets of offset(3,2) to get it to column C?

smiler44

 

[boblarson]

You can't go like that into a merged cell.

 

[smiler44]

I do not want to get into a merged cell but from a merged cell
Once at the merged cell I then want to offset from it
Smiler44

 

[boblarson]

I do not want to get into a merged cell but from a merged cell
Once at the merged cell I then want to offset from it
Smiler44

Sounds like your merged cell counts all of them as being together so you would have to move down first and then across to get to column C.

Is the range in Column C specific or does it change? So, in otherwords can you not go directly to C4 or something?

 

[smiler44]

Column C I have been told will be the same but the "4" could differ every time.
If you say down and then across is the only way then that's good enough for me.
thank you.
Smiler44

 

[chergh]

Merged cells offset from the maximum of the merged range. If you have cells A1 to C3 merged then any offset from within this range will give the same result i.e. Range("A1").offset(1,1) would return the range D4 as would B1, C1, A2 etc.