Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if+delete row
Is there any function to delete entire row if a cell is empty like this
=if(A1="",delete row1,"not empty") |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
if+delete row
This kind of action can be performed by a Macro:
Sub RowDeleter() With Range("A1") If .Value = "" Then .EntireRow.Delete End If End With End Sub Macros are very easy to install and use: 1. ALT-F11 brings up the VBE window 2. ALT-I ALT-M opens a fresh module 3. paste the stuff in and close the VBE window If you save the workbook, the macro will be saved with it. To use the macro from the normal Excel window: 1. ALT-F8 2. Select the macro 3. Touch Run To remove the macro: 1. bring up the VBE window as above 2. clear the code out 3. close the VBE window To learn more about macros in general, see: http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Gary''s Student - gsnu200855 "aditya" wrote: Is there any function to delete entire row if a cell is empty like this =if(A1="",delete row1,"not empty") |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
if+delete row
A function can do one thing: it can return a value.
It cannot format, it cannot copy/paste, delete.insert, on any other Excel feature Do you wish to delete all rows in a worksheet when the A cell is empty? A VBA subroutine can do this; let us know exactly what you need best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "aditya" wrote in message ... Is there any function to delete entire row if a cell is empty like this =if(A1="",delete row1,"not empty") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete the test values, but do not delete the formulas | Excel Discussion (Misc queries) | |||
How can I delete a macro when the Delete button is not active? | Excel Worksheet Functions | |||
How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
How do i delete a macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) | |||
How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions |