Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use Macro to delete this row??
What am I suppose to put this < section to get the row deleted?
I tried writing < Opp.Offset(0, 1).Selection.EntireRow.Delete but it's not working. Please advise. Dim shC As Object, shD As Object, Opp As Object, BPRole As Object, As Long, k As Long Dim ops As Object Set shC = Sheets("Results") Set shD = Sheets("New") 'Name of the spreadsheets For j = shD.Range("B500").End(xlUp).Row To 1 Step -1 Set Opp = shD.Cells(j, 11) Set BPRole = shD.Cells(j, 7) If (Opp = 100000) And (BPRole = "BPA") Then < End If Next -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro warning - how to delete macro | Excel Worksheet Functions | |||
delete a macro that isn't in macro list | 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 macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming |