Determining number of columns a cell is merged across (XLS)

[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!

 

[SkipVought]

Hu,

Check out the MergeArea Property.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

more specifically...

msgbox cells(1,1).mergearea.columns.count

to determine the number of columns merged with cell A1.


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Bengreen]

Checked it out. Works a treat.
Many thanks, and excuse the n00b

 

[SkipVought]

n00b is never something to appologize for.

Glad we could help.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]