I have a worksheet inwhich I am pulling information from
another worksheet. I have copied the formulas into the
first 500 rows of the receiving worksheet.

=IF(worksheet1!K2<"",worksheet1!K2,"")

Now I would like to do some verification check to if this
column has a value. Is there away to check if the cell
contains a value or formula?