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.

Sub LastRow()
Range("a65536").End(xlUp).Offset(1, 0).Select
End Sub

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

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


or even

Sub Search()
Range("A:A").Find("").Select
End Sub

[Mr.G]

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

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