empty row deletion

Hi all. I have a table that is constantly being added to and i am trying to make a userform to search through the data. At present i think the search function working but i cannot get the table headers to become headers in my listbox. As the table is being added to frequently i have a dynamic...

Hello - i would appreciate some help with finding empty cells in a row and then doing something when found. My code for testing is: Sub TEST_Find_EmptyRows_DeleteRow() Application.ScreenUpdating = False Dim r as Long Lastrow = Cells(Rows.Count, "A").End(xlUp).Row For r = 1 To Lastrow If...

hello - originally i was trying to see if all cells in a row were empty then hide that row, but I was getting nowhere. Now I am trying to check just two cells, "A" and "E," and if they are empty then hide that row. here is what I have: Sub hideBLANKRows() Application.ScreenUpdating = False Dim...

I hope somebody here can help me with some coding issues. I have been trying to do it via Record Macro but I am stuck. I need to accomplish this report as soon as possible. I have tried to add the code using Mrexcel HTML maker but it didn't work. I also have a workbook but I don't know how to...