1. M

    A VBA code to Insert new row if sequential numbering not matching

    Hello I'm trying to figure out a code that could insert a new row where the sequential numbering mismatching. As you can see in the picture a row is missing for POS 2. I would like a code that could insert, in multiple places, during the sequence. For example, in some cases the sheet could be...
  2. P

    Insert dashes within character string, within an array.

    ISO VBA command to insert a dash (hyphen) as the 5th character from the left, and 6th character from the right, in a string of varying length, within an array. For example... Column Z contains the following list of values: MSEAVIMA0013S MSEAVIRM0016S MOLPVIRM0017S MOLS130012S MSEAVIRM0011S...
  3. Livin404

    Good Evening,

    I have a listing of scheduled flights, and they are listed by departure dates and time. There may be days there are no flights (see image Oct 21 for example). I would like it to insert a date 21 Oct 2020 0000. Just one date, it doesn't have to match the previous or following days numbers. Once...
  4. J

    inserting pictures through vba, but the position and range doesn't match

    Hi, i made a macro by clicking the cell and inserting a picture image. But, the vba range and the sheet range doesn't match. ex. i want to insert a picture in cell b6 but it seems the picture inserts in between b5 and b6. this is my code below Private Sub Worksheet_BeforeDoubleClick(ByVal...
  5. C

    Excel VBA Errors when trying to copy and paste objects from Excel to Word

    Hello All, I have some VBA code that I need help refining. The problem I am having is inconsistent and unexplained errors, from my research it appears that the issue is with the clipboard crashing. How the VBA code works: I have an embedded Word documents with various bookmarks and reference...
  6. S

    Insert Text between two bookmarks of a word document into a new word document (after bookmark)

    Hello, i hope you all are healthy! I want to insert the text written between two bookmarks ("Beginning_old") and ("End_old") of an baseline word document, into a new word document. In the new word document, the text should be inserted between a bookmark called "Beggining_newdoc" and a...
  7. S

    Insert text from Excel into word document - after bookmark

    Hello, I hope you all are well. I want to insert text from an excel-cell (B16) into a word document. The text should be inserted after the respective bookmark ("B1"). I have written the following code: Sub InsertAfterBookmark() Dim objWord As Object Dim ws As Worksheet Set ws =...
  8. A

    Insert column dose not work

    Hi there I have an excel workbook and I can't insert any column in any worksheet. I will appreciate helping me on this. Here is the excel file .Excel file
  9. P

    Range.Insert not working when filter is active

    I haven't noticed this issue in regular Excel because I have an active filter, I can still right-click and insert a new table column. However, periodically, when I try to insert a new column in VBA, I run into a run-time 438 error when I have an active filter. Has anyone else experienced this...
  10. B

    Inserting Rows with formulas automatically populated from the row above

    I'm sure this is a simple fix, but I am trying to insert rows in an excel spreadsheet and I want the row I insert to automatically populate the same formula from the row above it. For example: In cell N6, I have =IF(C6="@",E6,0) In cell N7, I have =IF(C7="@",E7,0) Now if I insert an entire...
  11. J

    Referencing an "icon"

    On the INSERT menu of the Excel ribbon, right under "shapes" you can insert an "icon". Once you've done that, how can you reference the resulting picture via VBA? I tried searching but most of what comes up for "icons" is in relation to conditional formatting.... Thanks!
  12. H

    Insert rows with formulas based on a cell value

    Hey, Please I need help in this case; thank you in advance! I insert data and have the data in Table1 in Sheet1: <tbody> A1 DATA B1 Order =COUNTA(A2;A1000) (result: 2) A2 Car 1 B2 25 A3 Car 2 B3 45 </tbody> Every time I insert new data, new data might add/cut rows to/from this table...
  13. S

    Power Query - insert column by repeating single value from another query

    Hi, I have a power query qryTotalSales that simply has SalesAgentID and SalesVolume as an aggregate SalesAgentID SalesVolume 1 27 2 4 3 72 4 11 In another power query qryThreshold I have restricted...
  14. G

    Insert Found Column

    Set fnd = Range("8:8").Find("WBS", , , xlWhole, , , False, , False) If Not fnd Is Nothing Then Intersect(Range("8:5000"), fnd.EntireColumn).Copy Range("B8").PasteSpecial xlPasteValues Intersect(Range("8:5000"), fnd.EntireColumn).ClearContents End If Hello The code above is working...
  15. D

    Insert a picture into named excel worksheets by client id vba

    Hi everyone, I have a workbook containing multiple sheets. The first sheet contains a unique 4 digit id to identify the client. Other sheets within the workbook are named after a year group so Y1, Y2, Y3 and so on.... Elsewhere on my PC, i have files that are named with the 4 client digit id...
  16. C

    Using more than one formula in a cell

    I have the following in which i want to populate a notice using more than one formula, sorry my knowledge does not stretch to more than one formula :( I hope I have explained easy enough as below Any help would be much appreciated. Thank you <tbody> A B C D E F G H I J K L M N O Date...
  17. D

    Trying to insert a formula

    What is wrong with this code to insert a formula? ThisWorkbook.Worksheets("CSS_quote_sheet").Range("M11").Formula "=IF(D11<3,3,D11)"
  18. C

    Conditionally insert rows

    Dear MrExcel, I need to insert rows based on certain numbers and I need your kind help and assistant to help me out. I have 2 columns, A & B A is containing value (string) B is containing value (number) If the value in column B = 1 then no inserting rows But if the value in column B <> 1...
  19. A

    Insert a line break after word wrap

    I have a multi-line textbox I want to insert a line break after word-wraps to a new line. Can someone help with a vba code that can do this. Thank you kindly
  20. N

    VBA Code to insert the same data for many clients!!

    Hi, I have a userform with many controls, and below are some of them txtBarCode (TextBox) [where I insert the needed Item's Barcode] cmbNum (ComboBox) [(List from 1 to 8) to Identify the clients number] txt_Name1, txt_Name2 ...txt_Name8 (TextBox) [To insert the client names, (if cmbNum = 3...

Watch MrExcel Video

This Week's Hot Topics

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
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 "".
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