Determining number of columns a cell is merged across

[Bengreen]

I have a set of Excel spreadsheets which all have similar properties and I'm trying to automate a set of processes on them.
I'm a compelte VB beginner, but it's going ok - I've just hit a stumbling block which the internet isn't being very helpful with.
Once I have found a certain cell, is it possible to determine how many columns it is merged across?
Many thanks for any help!

 

[mrmovie]

best off in the 'vba visual basic for applications (microsoft)' forum

 

[Bengreen]

Thank you. I've moved it now...