rangek

  1. D

    modify data based on range

    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...
  2. S

    change code to stop sheet selecting or activating

    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...
  3. N

    VBA code taking about 40 minutes to run - why?!

    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"...
  4. C

    macro out ofmemory

    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")...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top