Hi.. actually my question is just like the title says.. i need to find out the first cell and the last cell of a vertically merged cell.. lets say i merge the Cells B2 down to B50 how can i get in VBA the start cell(=B2) and the end cell(=B50) ? thanks a lot