Select cell in bottom right corner of data

[ratm]

Can someone help me select the cell marked in red on the attached image. I want to add the title in the last column then input a formula in that column to all of the rows, but the number of rows will vary. i was thinking of selecting that cell then filup to the title of the column. Any other sugestions? Im a novice to VB so any help will be much appreciated, as was the reply to my last question. Thanks

[Granty]

Try:

Application.Cells.SpecialCells(xlCellTypeLastCell).Select