<div>
I love you Martin. &nbsp;this is magic
</div>


<div>
<blockquote>
I love you Martin.
</blockquote>
It's a good thing my wife isn't a jealous woman:)<br />
<br />
In any case I'm glad I was able to help.<br />
<br />
In <a href="https://www.experts-exchange.com/M_258447.html" rel="ugc">my profile</a> you'll find links to some articles I've written that may interest you.<br />
Marty - MVP 2009 to 2014
</div>


<div>
Thanks Martin. <br />
<br />
your profile is impressive. &nbsp;I liked the Using the Debugger &nbsp;article. &nbsp;it is so helpful.
</div>


<div>
If you want to you can give it a Helpful vote.
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
i have data and i want to get rid of all empty cells in each columns. i need vba to delete empty cells in columns and move up.<br />
<br />
then i have another sheet that also i need delete empty cells but this time move to the left.<br />
<br />
thanks.
</div>
</div>


Hi

i have data and i want to get rid of all empty cells in each columns. i need vba to delete empty cells in columns and move up.

then i have another sheet that also i need delete empty cells but this time move to the left.

thanks.

VBA to delete all empty cells and move up in usedrange

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.