PDA

View Full Version : Solved: Search Macro and Merged Cells



Mr.G
06-01-2009, 04:41 AM
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
06-01-2009, 05:01 AM
Solved.

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

MaximS
06-01-2009, 05:04 AM
use column "D" for your search

Mr.G
06-01-2009, 05:14 AM
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
06-01-2009, 05:49 AM
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
06-01-2009, 06:32 AM
Thank you again,mdmackillop. Your always such a great help.
:clap:

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