visual basic Loop by rows in Excel

[Carrie_Loos via OfficeKB.com]

I have a data range with merged cells and other cells not merged in a
spreadsheet. I want to find only the merged cells so I can store a lookup
function in them using visual basic. My problem is I can't figure out either
how to enter the function in the merged cells only and stop the loop so it
doesn't go into my titles, which are merged cells, and enter the function in
those. Any ideas?

Thanks

 

[Don Guillett]

I, among many, do not believe in merged cells but assuming your titles in
row 1, try this

Sub findmergedcells()
For Each c In Range("e2:e22")
If c.MergeCells = True Then MsgBox c.Row
Next
End Sub

 

[Carrie_Loos via OfficeKB.com]

Thanks - works great

I, among many, do not believe in merged cells but assuming your titles in
row 1, try this

Sub findmergedcells()
For Each c In Range("e2:e22")
If c.MergeCells = True Then MsgBox c.Row
Next
End Sub

I have a data range with merged cells and other cells not merged in a
spreadsheet. I want to find only the merged cells so I can store a lookup

[quoted text clipped - 6 lines]

Thanks

 

[Don Guillett]

Glad to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

Thanks - works great

I, among many, do not believe in merged cells but assuming your titles in
row 1, try this

Sub findmergedcells()
For Each c In Range("e2:e22")
If c.MergeCells = True Then MsgBox c.Row
Next
End Sub

I have a data range with merged cells and other cells not merged in a
spreadsheet. I want to find only the merged cells so I can store a
lookup

[quoted text clipped - 6 lines]

Thanks