VBA to return the column numbers of the start and finish of a merged cell? RANDOM!

I know this seems like a random one! but I have a really long merged cell called "Model Length". it can vary as to where it is on the sheet. what I want to do is return two variables one containing the column number of the start of the merged cell, the other to return the column number of the end of the merged cell.

I currently have

Please Login or Register  to view this content.

Which returns a list of all the cells in the merged cell but I cant figure out how to identify the start and finish points.

Please help

thanks

Jim

Awsome thanks tigeravatar and JasperD.

is there anyway to actually specify the merged cell that contains the text "model life" only? as if there are other merged cells it returns those values as well?

thanks

nailed it thanks tigeravatar. tbh I thought yours was a little long winded but actually yours is far more efficient just took a little while to get my head around!

thanks your a star