xrow

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

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

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

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()...

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

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

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

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

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?