Finding last cell

Excelnoobisme · Jun 11, 2011

i have a list of data in Column A.

how can i select the last cell in Column A that contain the word "Game" in vba?

rs2k · Jun 11, 2011

See if this works for you;

Code:

Sub FindGame()

   Cells.Find(What:="Game", After:=[A1], SearchDirection:=xlPrevious).Select
   
End Sub

HTH
Colin

VoG · Jun 11, 2011

Try

Code:

Columns("A").Find(What:="Game", SearchDirection:=xlPrevious, SearchOrder:=xlByRows, LookIn:=xlValues, lookat:=xlPart).Select