Hi JurgenC!
Dim MergeAr As Range
Set MergeAr = Range("C10").MergeArea
MsgBox MergeAr.Column & vbCrLf & MergeAr.Column + MergeAr.Columns.Count

HTH
Cordially
Pascal

"jC!" a écrit dans le message de
om...
hi all,

any advise on how to determine the start Column and end Column of a
merged Cell using VBA in Excel 2003 is mostly appreciated.

ie A3/B3/C3/D3/E3/F3 are merged therefore
Start = 1 (for A)
End = 6 (for F)

thanking for your help.

cheers...

...jurgenC!