| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find and delete empty rows
I'm trying to create a code that will carry out the following.
Check for entries in column 'U' from cell 7 downover until there are no more entries in column U (i say this so that it does not check all the way to the bottom of the sheet and take forever, may be wrong though). Then for every entry in column 'U', check to see if an entry exists in activecell.offset(0, 18). If no entry exists, delete that row. I have managed to do this by finding the last row and checking if that is empty and deletes if it is, but it only works once as I dont know how to loop and it also only checks if the last row is empty. Could any of you excel wizards help me out or point me in the right direction. Thanks Ian |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hpw do I delete multiple empty rows found between filled rows? | Excel Worksheet Functions | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| Delete Rows with Empty Cells with empty column 1 | Excel Programming | |||
| how do i find and delete all empty rows in an excel worksheet | Excel Worksheet Functions | |||
| Find last row of data and delete empty rows | Excel Programming | |||
Threaded Mode
