Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
delete row
If cell A4 has a value of 0. I am looking for the entire row to be deleted. Please help:( :( -- mikespeck ------------------------------------------------------------------------ mikespeck's Profile: http://www.excelforum.com/member.php...o&userid=34946 View this thread: http://www.excelforum.com/showthread...hreadid=564434 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
delete row
You will need VBA Code Try this. Press Alt + F11. Insert module then paste in the below code. Press alt F8 and run Delete_row. See attched to make it a event procedure e.g If someone enters 0 in cell A4 it will delete row automatically http://www.cpearson.com/excel/events.htm Sub Delete_row() Dim Rng1 As Range Set Rng1 = Range("A4") If Rng1.Value = 0 Then Rows("4:4").Delete Shift:=xlUp End If End Sub VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=564434 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
delete row
or:
in VBA: Sub row() If Range("A4").Value = 0 Then Selection.EntireRow.Delete ActiveCell.Offset(RowOffset:=-1, ColumnOffset:=0) End If End Sub "VBA Noob" wrote in message ... You will need VBA Code Try this. Press Alt + F11. Insert module then paste in the below code. Press alt F8 and run Delete_row. See attched to make it a event procedure e.g If someone enters 0 in cell A4 it will delete row automatically http://www.cpearson.com/excel/events.htm Sub Delete_row() Dim Rng1 As Range Set Rng1 = Range("A4") If Rng1.Value = 0 Then Rows("4:4").Delete Shift:=xlUp End If End Sub VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=564434 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
delete row
nothing seemed to work. If a 0 is in A4 I need to at least have the contents of cells A4,B4,C4,D4,E4,F4 be deleted also. -- mikespeck ------------------------------------------------------------------------ mikespeck's Profile: http://www.excelforum.com/member.php...o&userid=34946 View this thread: http://www.excelforum.com/showthread...hreadid=564434 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I can't delete a cell without deleting a row | Excel Discussion (Misc queries) | |||
How can I delete a macro when the Delete button is not active? | Excel Worksheet Functions | |||
how do I delete a worksheet from my workbook | New Users to Excel | |||
In a protected worksheet allow users to delete rows | Excel Worksheet Functions | |||
Delete row depending on criteria | Excel Discussion (Misc queries) |