Determine start column/ end column of Merged Cell

J

jC!

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

papou

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

HTH
Cordially
Pascal
 
Top