Select a Range of Cells Offset from a Selected Merged cell

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!

The following code finds your named range and selects a cell four columns to the right of that range.

Please Login or Register  to view this content.

This code does the same for range g13

Please Login or Register  to view this content.

This does the same for the cell defined by the variables RowNo and ColNo

Please Login or Register  to view this content.

Thanks for the reply guys!

I may have not been clear, I want the starting range to be a merged cell that I currently have selected on the sheet. So say, I select merged cell A71, which is actually A71-A90 Then I want to hit a macro and cells E71-E90 are selected, and so on.

Originally Posted by protonLeah

MR=Range("A1").mergearea.Rows.Count
Range("A1").Offset(0,4).Resize(MR,1).Select

Awesome! that works for the merged cell range, now my only question is, how do I have it use the selected cell instead of just "A1" ?

Thank you so much

Actually I just figured it out, this is what finally solved my issue. THANKS for your help!!

Please Login or Register  to view this content.