Hey Guys,

Having some trouble here, I'm sure this isnt too difficult.

I want to select a merged cell that is a range of cells in a column, and select the adjacent cells 4 columns over.
So I found this, but I need it to use the selected merged cell to get the range, not a static merged cell name. Cant seem to figure this out.

ActiveSheet.Range("Test").Offset(0, 4).Select

Thanks so much!