I need to find out the first cell and the last cell of a vertically merged cell..

Let's say I merge Cells B2 down to B50.
How can I get in VBA the start cell(=B2) and the end cell(=B50)?

Edit
Report