| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Delete a Row
Oops. Ignore this message.
Dave Peterson wrote: Check your other post. Ty wrote: I posted a problem under "Excel Delete VB Macro" in the microsoft.* public.*excel.*worksheet.*functions. And another one called VLOOKUP in the last 5 days. All of the problems were resolved. i have 3 more questions. What if I just wanted to delete rows that have the cell blank? my answer: ActiveCell.Interior.Color = RGB(255, 0, 0) need to change the RGB to the empty cell numbers(0, 0, 0) What if I just wanted to delete rows that have #N/A in the cell blank? my answer: ActiveCell = #N/A What if I had another column such as column J as a condition to the above to not delete with my initials like TB? my answer: If ActiveCell.Interior.Color = RGB(255, 0, 0) + column J is blank. Don't really have answer but I'm trying to figure this out on my own. Thanks for your help.... Ty -- Dave Peterson -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Threaded Mode
