rrng

  1. J

    Find integer value in big range

    Hello, I have a Input Sheet(Sheet1) and a Calc Sheet(Sheet2). at the inputsheet i have a range (B12:2750) where i have to find only the cells that are filled with an integer. (The integer is the value that i have to order.) <vb> Sub PrintNumber() Dim i As Integer Dim rCell As Range Dim rRng...
  2. Y

    Using Offset in a For Each loop

    Hi, I currently have this: Private Sub CalcPUnit_Click()Dim rCell As Range Dim rRng As Range Worksheets("Inventory").Select Set rRng = Range("E3:E50") For Each rCell In rRng rCell.Value = rCell.Offset(, 2) / rCell.Offset(, 1) Next rCell End Sub Basically to say each cell in a range...
  3. D

    VBA Find first instance of word

    Hi, I have a column of data and every cell may or may not contain specific words, what I am trying to do is once the first instance of a word (from an array) is found then insert a column before the data column then exit completely out of the loop without looking in any other cells in the data...
  4. J

    VBA to replace first four digits of a phone number using regex

    Can anyone help me amend this snippet to instead of adding periods to break up a phone number to replacing the first four digits with an "x"? Thanks, J Sub SymbolsInPhN() Dim rRng As Range, rCell As Range Set rRng = Range("A2", Range("A" & Rows.Count).End(xlUp)) With...

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