Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
use vb to delete marked rows
Having trouble with this one, hope someone can help me with the code.
I have a sheet with rows 3-700 and columns A-J. I want to have some vb code that when run(doing it on a click action for a button) deletes rows that I have marked with an X in cell J3-J700. So if it sees a X in cell J3, it highlights the entire row and deletes it, then move on to J4 and checks for the X and so on. If there is no X then it should just move to the next one and keep checking. I can get it to sort of work with if/then statements, but one problem I'm having is when you delete a row they all shift up, so just going to the next row starts to "skip" rows that were moved up. And the other problem is how to simplify the code for J3-J700 so I don't have to put 700 if/then statements in. Thanks for any help. |
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 | |||
Marking cell; totaling all # between marked cell & next marked cel | Excel Worksheet Functions | |||
How to delete all stuff outside marked cells ? | Excel Discussion (Misc queries) | |||
Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions |