charity

  1. B

    IFERROR or Error On in VBA

    I am fairly new to coding in VBA and was wondering how to add an error formula to the following string of code: For I = a To lastRow If Range("I" & I).Value / Range("H" & I).Value > 1 Then Range("P" & I).Value = "Review" Range("Q" & I).Value = "Review" Range("R" &...
  2. B

    Compile Error: Variable Not Defined

    Hey there! I am trying to get some code to work and had a friend help me try to clean it up. It worked when he ran through it, but now I am getting a Compile Error. I have made the line where the error occurs bold. The string of code is as follows: I would also like to add that I renamed...
  3. B

    Autofill with VBA

    Hey all. I am using the following code to attempt to autofill a formula to the last row as defined. I am receiving a 400 error and was wondering if anyone has a solution. Thanks Dim lastRow As Long lastRow = Range("L" & Rows.Count).End(xlUp).Row Sheets("FYXX-XX Charity Care...
  4. D

    VBA Lookup, Cut, Delete, and Move

    I have taken on an overcoming task of trying to help a friends charity make an inventory process more efficient. I have landed myself in over my head on VBA programming and am in need of help. I have a page that they enter in the stock number and press submit. On submit, I want it to search...

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