Finding and returning first column that contains data - VBA Excel
<p>I am trying to locate the first column that contains data in a given worksheet, I have seen various formulas from searching online but I am not getting the correct value. I have tried the formula from this website but it is not working.</p>

<p><a href="http://www.vbaexpress.com/kb/getarticle.php?kb_id=418" rel="nofollow">http://www.vbaexpress.com/kb/getarticle.php?kb_id=418</a></p>

<p>Any ideas?</p>