rangek

i want a macro that loops from column K in sheet I'll call "ABC" and checks the values against a data range called "filter" (which is in another sheet called "filter criteria") if it finds a row in column K that's also found in the data range "filter" (eg the number 005), then it'll zero out...

Hi All I want to change my code to just run without activating or selecting the sheet. Its not a major problem of course, but its just neater. I have been trying to figure it out, but cannot, so please see code below that works. It loops the 6 sheets and then goes back to the main...

Hi, I have this code: For rw = 2 To num Application.StatusBar = String(3, ChrW(9609)) & "Scrubbing at row " & rw & "/" & num & "." If InStr(Range("L" & rw).Value, "1") > 0 Then Range("A" & rw).Value = "#" Range("K" & rw).Value = "#" Range("M"...

Hi I have the following which repeats itself over and over, until the point whereby excel cannot run it. The only difference in each section is the reference to the cells highlighted in red. Is there a way to consolidate it into a few lines? Thanks Paul With Sheets("Gross Pay")...