Solved: Search Macro and Merged Cells

[Mr.G]

I have a search Macro in attached book and it searches down column A for first empty cell. Now I have cells in Column A that is merged and it doesn't search past those....Any Ideas?

Thank you

[Mr.G]

Solved.
[VBA]
Sub LastRow()
Range("a65536").End(xlUp).Offset(1, 0).Select
End Sub
[/VBA]

[MaximS]

use column "D" for your search

[Mr.G]

Thanks but you would want to search in row a,b or c. The values in d could vary from one to seven. Thank you for your time.

[mdmackillop]

[vba]Sub Search()
Dim c As Range
Set c = Range("A:A").Find("")
c.Select
End Sub
[/vba]

or even
[VBA]
Sub Search()
Range("A:A").Find("").Select
End Sub

[/VBA]

[Mr.G]

Thank you again,mdmackillop. Your always such a great help.


Would be great to have half your talent. ........one day...