1. Mister_J

    Help setting fixed values in an amazing macro that splits columns using dialog box feedback!

    I have an amazing macro that uses dialog boxes and allows you to select a column of data, and break it up into multiple columns based on a number of rows you select. Then output those columns starting in a cell of your choosing. Starts as: (I choose 2 rows per column) 1 2 3 4 5 Becomes: 1...
  2. G

    Delete rows based on empty cell

    Hi, I know there are a few threads on this but I haven't found one that works. I have a column, column A, that contains headings in the rows. Column B will contain the appropriate data that corresponds to the heading. However, any data that does not apply will be blank in Column B. I would like...
  3. M

    Save exported excel from Outlook with Subject name

    Hello - I am creating a macro to export an HTML table embedded in a Outlook email to Excel. The exporting piece is fine, however I am having troubles when saving. I would like to save the new file in a specific folder and the name should be the subject of the email. I am having issues with the...
  4. S

    VBA - After new row pasted, make value in particular cell zero

    I have the below code working perfectly but I need value in cell column "N" of the new pasted row(s) to be zero. But I need the value in "N" of the original copied row to retain it's value. below is my current code. You can ignore the comments. I was trying different places. Sub CopyData()...
  5. B

    Error while looping through column and deleting specific values

    Hello, In the below code I am trying to delete cells that say Inactive in column G, then I create a new column B filled with Vlookup values some of which return errors as "#N/A". The last part is identical to the earlier column G code but is supposed to delete cells with #N/A in column B...
  6. L

    VBA Type Mismatch on Worksheet Change event

    Hello All, Here's what i'm trying to do: I have a userform which prompts the user to populate numbers when a drop-down value on column D is "Yes". And based on the entered number, current row will be replicated. However, I am running into Type Mismatch error 13 after the row is replicated...
  7. Z

    VBA Code: Recursive File Rename?

    Hello all, I'm trying to adapt the below file rename code in order to be able to operate recursively (i.e. perform the operation on all files also found within subfolders of the chosen folder), preferably using File System Object, but I'm having trouble figuring out how to do so. Sub...
  8. D

    Macro unique number lookup - exact match required

    Hi All, I am using the following code: Sub ReturnInvoice() Do Dim myWord$ myWord = InputBox("Insert the Voucher Number", "Voucher Search") If myWord = "" Then Exit Sub Application.ScreenUpdating = False Dim xRow&, NextRow&, LastRow& LastRow = Cells(Rows.Count, 1).End(xlUp).Row NextRow =...
  9. V

    Advice on how to rework this code to work on a mac operating system!

    Good morning, I have the below script that works perfectly well on a windows machine. However it doesnt run on a Mac Operating system. Can I get your guidance on what I need to do to the code?

Some videos you may like

This Week's Hot Topics