| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to write to macro to only delete rows under certain conditions
Hi there,
I need to delete rows of data which the last column in the range is either a blank or a non-integer. If the last column contains a integer, it does not delete that particular row How do I do that? example given below: A1 1.3233 A2 A3 6 A4 0.823 A5 A6 9 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i write a macro that will add rows into a spreadsheet | Excel Discussion (Misc queries) | |||
| Delete rows from a protected sheet (write macro) | Excel Programming | |||
| How do I write a macro to delete all rows from the first empty ro. | Excel Programming | |||
| How do I write a macro in XL that will delete 1st row and save th. | Excel Programming | |||
| How to write a VBA code to select certain rows based on certain conditions | Excel Programming | |||
Threaded Mode
