Select first empty cell

Hi,

I'm new here, and need some help!

I've been tasked with creating a spreadsheet at work to help give customers quotes on price plans (cell phone store!)

Anyway, I'm stumbling through this and learning macros and what have you, with the little bit of VB knowledge I have, I'm stuck.

I need to put a formula in my macro, that will go down my "A" column and select the first empy cell, and then input some data. The data part I have down, I just need to know what the code would be to select (or highlight) the first empty cell in my A column.

Thanks in advance!

Thanks!

I'll give this a go when I'm at work again tomorrow!

I tried the first solution, and I'm still somewhat of a noob, so I wasnt exactly sure how to input it. Still working on it tho, with the 2nd solution offered. Thanks! I'll let you know how it goes!