VBA Select First Blank Cell in Range

[ExcelKnut]

I need to select the first blank cell in range("G2:K99") starting in row 2, then row 3 etc. I've used the code below but it seems to search column G first. For example, it might select cell G9 even though cell I3 is the first blank.
Any help is greatly appreciated.

Range("G2:K99").Find(What:="", lookat:=xlWhole).Select

 

[DanteAmor]

Try this

Range("G2:K99").Find(What:="", LookAt:=xlWhole, SearchOrder:=xlByRows).Select

 

[ExcelKnut]

You're the man!!!! Thank you so much!

 

[DanteAmor]

I'm glad to help you. I appreciate your kind comments.