Last Cell in a Variable Length Column

I'm trying to teach myself VBA. In the meantime, here's a problem I'm faced with: I have a column of which the size can vary anywhere from 1'500 cells to 10'000 because I'm pasting in the data (so sometimes less data sometimes more). I'm wondering if there's a method that'll always detect the value of the last cell in the column, regardless of where that occurs, and publish that value to another cell? E.g., examine column B, find the value in the last non-empty cell in the column, and print that value to cell E12. I thought there'd be a straight forward formula for this, but not as far as I can tell... so I'm turning to VBA. Any suggestion, formula or code would be highly appreciated. Thanks in advance.