rangei

  1. T

    Matching value in Range("A5") against a list of items

    Hello, I have a script with an IF Range("A" & r) value is also in a lookup list AND Range("I" & r) THEN do something. I know I can do a bunch of ORs but that doesn't seem particularly neat. IF Range("A" & r) is in Lookup list named Type AND Range("I" & r) IS NULL Then DoSomething. Any ideas...
  2. G

    Show names in message box.

    Hi everyone, I am using vba to count the number of cells in a worksheet that contain "0" and the number of cells that contain a value then display the results in a msgbox, this code is working fine... what i would like it to do if possible is to also show in the same message box the members...
  3. A

    Offset previous row

    How can include offset the previous row in the Red Color code? For i = 3 To LRow Range("I" & i) = WorksheetFunction.Average("I" & i, "L" & i) Next i
  4. S

    My second part of code is about populating no of months in G cell when no of days Is given in F cell and vice versa. But it throws run time error 13 w

    Private Sub Worksheet_Change(ByVal Target As Range) ' If the target column is greater than J And J isn't blank And K is blank then... If Target.Column > 9 And (Range("C" & Target.Row).Value = "CP" Or Range("C" & Target.Row).Value = "NCD") And (Range("I" & Target.Row).Value = "" Or Range("I" &...
  5. A

    VBA Case Statement: Continous calculations

    I have a Case statement running with a worksheet_change event. I noticed that anytime a change is done it go completely through the entire worksheet step by step through the module. The worksheet has 75k rows so it literally takes forever. Is there a way to make this procedure only do the...
  6. A

    VBA: If cell contains [criteria] enter data

    First off, I just started to really learn vba, so I'm clueless to some of this stuff but I do know how to research and learn. Now, I have a worksheet that I to automatically input data into cells when specific columns are changed. I've been working and searching for hours and I have had no...
  7. B

    Last piece of the puzzle!

    Good afternoon, I have written the following code: Sub NewPO() 'Cleardown unused PO numbers Range("e" & Rows.Count).End(xlUp).Offset(1, 0).Select Selection.EntireRow.ClearContents 'Generate new PO number based on last number in coloumn "i" Range("P4").Value = "GG" & Range("I" &...
    • Bengo
    • Thread
    • cell copy number rangei rows.count.endxlup.value
    • Replies: 9
    • Forum: Excel Questions
  8. G

    While + If Statements in VBA

    Hi, I have a worksheet full of data for which I would like to create serial numbers, given certain critria are met. I'm using the "While" function to loop through rows, for as long as they have some text. Then I'm utilizing an "If Statement" to see if 3 criteria are met. if so, I would like...

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