I am trying to create a macro for removing rows of data when data in column "Z" has values of CN,AL,...and so on. After removing the rows of data the macro needs to move the row below it to that position. Any help would be grately appreciated.
I am trying to create a macro for removing rows of data when data in column "Z" has values of CN,AL,...and so on. After removing the rows of data the macro needs to move the row below it to that position. Any help would be grately appreciated.
When you delete a row the row below usually occupies the vacated position - exactly what do you mean by and so on???
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks