vba & excel 2013

So I have some code that I have written referencing arrays, named ranges, and ranges. I have taken the workbook and re-designed it to be table based. I figure I will have to re-write the VBA code to reference the table objects instead of the ranges, right? Is there a simple way to do this or...

Hi, I have a horrible table with information which was left to me. A bit of the legacy the previous dude left. The table goes like this: <tbody> Order Material SizeA1 SizeA2 SizeB1 SizeB2 SizeC1 SizeC2 Doz1 Doz2 1234 MAT1 30 31 A AA GM GN 24 63 4321 MAT2 40 44 XL 4X MN MO 524 636 5443...

<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier...

I have written a macro to create a Pivot chart in Excel in one Workbook. If I am running the macro from the same workbook it is adding the pivot chart proper without any error. But if I am running the macro from another workbook, I am getting the Application defined or Object defined error in...

Good evening, I am needing some VBA to select the correct word merge template based on a cell value. I receive a spreadsheet with all of the data to perform a word merge. Not every row will be the same template. I need the template used to be determined by the value in column "A" For example...

I have some code that will check to see if a change has happened in worksheet Quotes, Column "C". If it has, and Column "B" is blank, it will then place a datetime in Column "B" and then an ID from worksheet Misc. Worksheet Quotes is made up of a table. Worksheet Misc, range QuoteIDList is a...

Hi, I would like to delete all columns that only contain Blanks, or "n/a". I want a code that deletes based on whether the column contains anything other than a combination of a specific word e.g. "n/a" and/or trimmed Blank cells e.g. "" and/or " ". If it contains something else e.g. other...

Hi I've written some VBA code which selects then deletes certain columns. I then want to cut two columns and paste them at the end of the data. I've written the code below, but Excel doesn't like the last line, where I've selected column U and attempted to paste the columns I'd just cut...

Hi Folks, I've created a multi-macro excel model that I've saved as a *.xltm file i.e., so that the users cannot damage the original file. As hoped, when opened the file becomes filename1 instead of filename.xltm. I can account for this in my vba code by referring to the workbook as...

I have code that watches three different columns for changes. It works great when only one cell changes at a time. But if I copy and paste multiple cells of data in to the columns at a single time, it doesn't work. I am pretty sure that I know why, but I can't figure out how to change it to...

Hi Guys, I need some help with my script below. I have no issues with part one of the script until when it starts going to the 2nd URL. I'll like the following to be done: 1. I'll like the "Live1" option to be selected. 2. The text to be copied and inserted from excel 3. From the masterIB...

Good day Friends! I have a folder with dozens of spreadsheets that I need to print. I only want to print the files that contain the word "COMPLETE" in the filename. It would be much preferred to not have to open each file to print as there are a ton. Thank you!

Hello guys, I am struggling since a couple of days to create a macro (button) that by clicking will copy the row to the table in another sheet. From this sheet, "Price List (sugaring)" I would need a button for each and every row. (basically working as a select button, each time pressed...

Good Day, I am trying to copy data from Sheet1 (which meets the conditions of an IF statement) and then paste the relevant cells for said row into Sheet2 of the same workbook. Initially I managed to use the following code to simply pull in the relevant rows: Sub Copy_to_Sheet2() a =...

Hi All, this is a most excellent forum with a wealth of information and a wonderful user base! I have learned a lot from this forum, and see many thoughtful answers. I have a macro which I need help with, I'm attempting to display a list of RGB codes to the recent colors section within excel...

it keeps ignoring the last condition... If zz Like Left(Replace(activ_code, 0, "?"), Len(Replace(activ_code, 0, "?")) - 1) & "1" _ And Left(zz, Len(zz) - 1) <> Left(activ_code, Len(activ_code) - 1) _ And...

I have a sheet that I am importing data from a CSV file that I then unlink it from the data and format it as a table. This works perfectly when I do it manually but when I attempt to do this with a Macro I always get a "Run-time Error 1001" unless I save and reopen the file. I delete the...

Hello, I am still picking on my VBA but not there yet. I am trying to work on a vba code that will open a webpage from a cell in excel scrape into a formatted text and place into a single cell in the same worksheet. The pages i am trying to grab are not the same in structure. After searching on...

Good day, I am trying to sort a table that updates from Master Data Services add-in on Excel, by using VBA. I cannot reference the table (ListObject) name, as the name might change everytime the table gets updated when a connection is established. The name of the sheet on which the table is is...

Hi Folks, I have excel data---columns A and B---populated by 3 digit numbers <tbody> 278 192 148 112 168 325 279 261 306 38 292 259 135 654 </tbody> There are a few thousand lines of these numbers. I would like to import these numbers (one number per label in the same layout as...