Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Delete Row syntax conundrum
I have a button where Users can click to create new rows to specify 'Audiences' for a communication. When they click the button a new Audience row with a cell with a drop down in appears each time. However when I want to 'Reset' the worksheet I only want there to be one Audience row remaining. I guess I need to check the cell to see if there is a list item in it and if so delete the row that the cell is in. I have: Sub IfStatement() If Range("A20") = List Then Rows("20:20").Select & Selection.Delete & Shift:=xlUp End Sub But I get compile errors - probably because I have the wrong syntax. I'm not massively technical so can anyone help out on my syntax at all please? Thank you very much. -- username ------------------------------------------------------------------------ username's Profile: http://www.msusenet.com/member.php?userid=1433 View this thread: http://www.msusenet.com/t-1870445735 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to delete blank rows | Excel Discussion (Misc queries) | |||
Macro to delete data in 'green' cells only | Excel Worksheet Functions | |||
How to delete macros | Excel Discussion (Misc queries) | |||
delete row contains specific word in an macro | Excel Discussion (Misc queries) | |||
Saving to a network share without delete permssions | Excel Discussion (Misc queries) |