Find last empty cell from range, then delete rows?

Please, dear Excel, how to find last empty cell or last NOT empty cell from three columns, then delete rows? Using VBA.


john MArk Julia
Johnson john Mark
John












How to delete empty rows from third column to down, actually I have B2:B15, K2:K15, T2:T15, I need to delete rows from 5:15. But sometimes there will be more data in B or K column, I need to find last non empty cell in these ranges and then delete rows:15
Thank you in advance!

Please Login or Register  to view this content.

This code not working, it watches only B, and then deletes all data from rows
Sorry bad english
Also asked on OzGrid http://www.ozgrid.com/forum/showthre...=201011&page=2
, MrExcel, http://www.mrexcel.com/forum/excel-q...lete-rows.html

MicrosoftCommunity... http://answers.microsoft.com/en-us/o...=1473072648304

Hi,

Can I suggest you upload the workbook and clearly explain which rows you want to delete and why you choose them. I find your first sentence confusing.

B2:B15, K2:K15, T2:T15 these are ranges. Always.
I need to find last populated cell in these three ranges, and then delete empty rows.
Lets say I have B2:B5 values, K2:K4 also cell populated, and T2:T7 populated. I need VBA code to find that last populated cell(T7) and then delete all empty rows to row 15 (empty rows(cells) from 8:15).
Thank You in advance, thanks very mach. Sorry bad englishh.

Ps And there will be time when all cells will not be empty, and also when all ranges will be empty. Thank you.

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)