Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Because I am not real skilled at this, I understand what Option Explicit
means and that I have to dim certain pieces of code .. I do not know what to dim as I'm getting an error for the rw in this code. Can someone help me with this? _____________________ set rw = cells(rows.count,"F").End(xlup) list = Array("DRH1", "DRH2", "DRH3", "DRI1", _ "DRI2","DRI3", "DRIA", "DRIB") for i = rw to 1 step -1 res = Application.Match(cells(rw,"F").Value,list,0) if not iserror(res) then cells(rw,"F").EntireRow.delete end if Next |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming |