Question Loop to test if cell has anything in it?

[awooster]

I want to use a loop to check to see if there is any data in the first column of a row, if there is data I want it to go to the next row and check again, once it finds an empty row, I want it to right data from an array I have created. I understand the concepts of loops and incrementing to make it go down one more row, but I cannot figure out how to check the particular row in the first column to see if it is empty or not. Can anyone help me with this If Else statement, how should I be evaluating this?

 

[awooster]

I have to input this data into two different excel files and a website, just trying to make it so I only have to enter the information once and have it populate all three. But even just putting the info into this vb app and having it populate the two excel files will definitely help out. so what I have right now will be an improvement.