excel 2016 vba

Hello, I have a worksheet with a long name "Timeline_123456789.24", and I want to know what sheet number it is. I don't want to have to type the whole name, since it's the only worksheet with this name. I was hoping to use "Temp*" to find it but it doesn't work. Is there a way to use a...

I am using code to copy over certain columns if two conditions are met, however, I would like for the code to replace what is already on 'Emerging' (the ultimate sheet). Any guidance would be much appreciated. [code] Sub Emerging() Set i = Sheets("Under achievement data") Set e =...

I have names in Col(A) and data in col(B:R). No duplicates in Col(A). Col(B) are dates Col(E:K) have data from 2017 Col(L:R) have data from 2016 I import new data (for 2017) to Col(Z:AG) After processing new data, it's transfered to Col(A:K), last row + 1 Now I have many duplicates in Col(A) and...

Hi I have a code to select/deselect all checkboxes with one "master" checkbox. This code is for OLEObjects/Active X controls, and im having a hard time rewriting it to work with Form Controls checkboxes. Any idea? Private Sub CheckBox1_Click() Dim i As Integer For i = 2 To 39...

Hi All, I have an Excel VBA macro that runs perfectly fine in 2010 and 2013, however it bombs in 2016 when it encounters the setting of the plot size characteristics. Following are the specific settings in my code that give me trouble now: .PlotArea.Width = 630 .PlotArea.Left...

I am using code to transfer data that don't have a blank cell in column A from "Data" to "ForIndustry". While the code works, I would like to only transfer columns A:P rather than the whole row. Any guidance would be much appreciated. Sub transfer() Set i = Sheets("Data") Set e =...

I have been using API code similar to https://www.mrexcel.com/forum/excel-questions/6148-possible-hide-excel-title-bar.html successfully to hide the Title Bar (min, max, close, menu buttons) in Excel 2013/2016 running Win 7/Win 10 and it has been working without issue on tablets when rotating...

Hi all! I am trying to rename all the tables on a worksheet and understand that I need to use VBA to do so.. I'm not very experienced so I was wondering if I can get some help here. Basically the layout of the table is like this: <tbody> Name Part 1 Name Part 2 Column1 Column2 Column3...

Hello, I need help on this. I have a pivot table with the following columns: Manufacturer Name MPN Commodity Family Project Name Contract Manufacturer Unit Material Cost Volume Spend I want to add filters above the table so it will look like this. Enter...

Hello Dear All, There is a table in excel 2016 made out of a SQL Query which is linked to a few pivot tables, each month we open the SQL query in Query Editor and change the parameters and save. Later we refresh all the pivot tables to update. My Question is: Is there a way to change or update...

I have an excel sheet similar to the following: ColumnA ColumnB ColumnC George 1 14 Edith 1 16 Archie 1 26 Betty 2 32 Fred 2 34...

hey i have a list in the same cell separated by , ex: <colgroup><col width="229"></colgroup><tbody> 1,2,3,4,5,9,22,23,24,25,244,245,246,247,248,249 </tbody> and so on i want it to be converted into 1-5,9,22-25,244-249 any help would be much appreciated.Thanks

I need help with the syntax to pass the query name and set a table's datasource from an existing list of queries within the workbook. I tried to modify the syntax for the LoadtoWorksheetOnly code from the suggested code sample, but I am not familiar with using a workbookquery. I am trying to...