snippet

  1. H

    Paste from clipboard, VBA

    I have created an overview sheet for a project where I also want the user to include a map of the location. The map should go in a special place of the overview (certain cells or a shape) and preferably look nice. Some user will have very limited experience. I have found that you could fill a...
  2. R

    Entering Specific Text Until Last Row

    I'm trying to update the contents of column E with "BKI Hold", starting with cell E2, as long as the cells in column A are not null. I want to continue entering that value, until the last row. I've tried a couple of routes. The first snippet only entered "BKI Hold" in E2, but not subsequent...
  3. E

    Multiple Vlookup and/or Index Match multi criteria.

    I need to pull together a table figures with the following criteria. Please see the snippet below: https://imgur.com/a/u9mW57l
  4. A

    formula strings aggravation

    Excel 2013 macro code snippet: ActiveCell.FormulaR1C1 = "=MID(D2,FIND(""."",D2,1)+1,FIND(""."",D2,FIND(""."",D2,1)+1)-FIND(""."",D2,1)-1)" This formula within the quotes works (I'm using it in another excel file), but when the above code snippet sets the cell value, the actual resulting...
  5. V

    This code works well WITHOUT an "Or" statement added to it, but doesn't WITH the "Or" statement

    Hello All, There are 2 Code snippets below. The first code snippet works fine, but the second code snippet with the additional code highlighted in red does NOT. Does anyone know how to fix this? Thanks FIRST CODE SNIPPET Sub Forum_Question() Dim LR As Long Dim...

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