I have two questions. First, I want to search down a column. If the first
row is blank, skip to the next, if blank skip to next, so on... I want excel
to stop at the first row that has a value in it, then set that value into a
declared variable. If there's no value within the entire column, then leave
the variable as an empty type value.

That's it... piece of cake for you guys... I can't get the syntax right to
save my life!!

Thanks!