proceed

  1. N

    Fill Column with Pattern

    I need to fill a column of my table with VBA as follows: IS100 IS110 IS120 IS130 I can select the range as follows but not sure how to proceed after: Range("table_admin[Sequence]") many thanks Andrew
  2. M

    IF statement condition row by row until satisfied

    Good day, is there a way to make an IF statement, row per row? The condition is that A2 is blank, then if will look at A3, if still blank, it will proceed to A4, etc. Thanks
  3. C

    Find value in list

    Hello I want a macro to find a value in a list then carryout further steps. If value is found proceed to step 1. If value is not found proceed to step 2. So far I have no problem if value is found, but if value is not found as expected I get run-time error 91, at this point I want to proceed...
  4. V

    If and Else If to Insert Rows basis various Conditions

    Hello, I have a Column with 1, 2 and 3. The number of 1s, 2s and 3s can vary. Also there are 6 combination Options in which they can appear, grid below. I need to insert Rows after last 1 and last 2. If the result is only 3 Option F below I need to proceed with the next step. <tbody> Options...
  5. S

    stop string or range before it goes forward to next command

    Hi There, I have an VBA macro an it must stop when cell is not filled in , I want it to go back to the sheet to fill in the cell and the it must proceed whit the next command. Steel010
  6. R

    Random Number Generator

    I need the kind assistance from Excel expert in the forum. How to generate random number between 1 to 36 based on numbers from 0000 to 9999 ? Anyone can give some tips to proceed ? Thanks.
  7. B

    Clear Contents If

    Good evening Looking to clear all if any one of the following worksheets exists otherwise continue to add the sheets if they do not exist. Not sure how to proceed With ThisWorkbook On Error Resume Next .Sheets.Add(after:=.Sheets(.Sheets.Count)).Name = "RegionA"...
  8. T

    Selecting certain characters within a cell

    I have data in cells that vary between 13 and 14 characters. AA1234567BBBB or AAA1234567BBBB I need to be able to extract the 1234567 data from each cell, but am not sure how. Can I somehow use the LEFT function to grab the 7 characters the proceed the last 4? Thanks!
  9. I

    Look for certain text and paste a phrase in new row for each cell containing that text

    So I'm looking for a very simple script that will search for the specific word "proceed" in every cell of column D and paste the phrase "completed and verified" in a new row below the existing text in those cells that contain the word "proceed". I'm very new to VBA. Can anyone help me with this?

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