vba 2010

How can I compare two list, one is on sheet 1, the othet list is in sheet 2, and eliminate duplicates in one of them. in sheet one the list is in L2:Q1500 in sheet two I have the other list in A1:F1500 I need to delete the duplicate in sheet 1 and keep 2

I am looking for a procedure to calculate the statistic range in a list, A4:F19 is my example list and in H4:H19 is the range, in this little example you know is easy just =F4-A4 but in my data is more than 2 thousand lines. I would like to choose the interval of the range, mean select min and...

I want to calculate the range of some rows, for example substract cell G1-B1 and the result in J. I didn't found nothing simple on internet. maybe something as Range G1 as integer Range B1 as integer , I have code generate thousands of combination so I want the range only.

I have a chart that is set to dynamically update to reflect the last two years of data from a data table. The updating is accomplished through OFFSET and COUNT formulas saved in Named Ranges. The chart depicts percentages as the data and on the Y axis and months/years on the X axis, plotting the...

Hi All, I have recently migrated to Excel 2010 from Excel 2003. In Excel 2003, I created an Add-In that had 20 bespoke macros in it. Everytime a user opened Excel 2003, the Add-In was deleted and re-installed (from a shared drive) using VBA coding within the "Personal.xls" workbook. This...

I am trying to paste a single cell value to a range that will vary according to row counts in two different columns. I'm pasting in column B so I want to use .Range("B" & BRowCount) as my starting value. I then want to paste the value down column B until I reach the last used row in column C...

Hi All, Just wanted to post this out there in case it could help someone out. I work alot with exports from one of our companie's application that gives out .csv files with thousands of columns. When working in VB, I noticed that my scripts were running way too slow on these files. I have...

I am using Excel 2010 and I needed a way for my co workers to stop leaving the document open. I used the following code. Private Sub Workbook_Open() Changed = False Application.OnTime Now + TimeValue("00:30:00"), procedure:="ThisWorkbook.Auto_Close" End Sub Private Sub...

Hello, I am working on a function that should compare a String originalName to a list of names. I use a While loop with an if statement checking at every line of the list whether or not the content is identical to the string in argument. However, when I run the function step by step, when I...

Hello I'm working on a project which involves userforms and listviews. I use a hidden sheet to get a customer's data (date, shopping date etc). The data is fetched as soon as a customerID is put into cell BN41 with an advanced filter. That works OK. The problem is populating the listview with...

Hello, I’m a newbie at programming in VBA So I hope someone here can help me along. What I’ve been trying to do these last weeks is getting a nice looking overview of empty locations in our warehouse. I Actually did get it to work(barely) with the conditional formatting function. However since...

Hi peeps, I am using a row of autoshapes to show a key underneath a macro-cotrolled map made of other shapes, whose colour depends on various values. There is column of data for the key with ten rows; one for each shape in the key. This column of data holds RGB values for the shape colours, in...

I was just sent a new workbook with macros to use to track my numbers at my new job. This particular macro is used to combine all the different sheets into one master sheet. When I try to run it, i get runtime error 13:type mismatch. Here is the code from the debugger. The error is coming...

Hey guys, I have this outrun VBA code that loops a string that places thousands of images in an excel spreadsheet. It starts out running pretty fast but as the images add up in the spreadsheet it eventually grinds to a halt. I need some help fixing the slow pace it runs at toward the end of the...

First time poster here so I hope I do this correctly! Using Excel 2010 I am creating a form that will display different rows if certain selections are made. For example; cells B70-B72 are a drop down list with two options, '-' or 'sqrt'. If none equal the 'sqrt' symbol then I want to hide...

Hi, as a supervisor in a 53 chain-restaurnts, weekly I have to visit 6 of them by suprise (avoid patterns, really mean), in the sheet below you see 3 tables, my database B1:G1874, in the middle the gaps ( 5-28=23 etc) and at the right side the table generate by the gaps 1870 only. all the gaps...

I am trying to update multiple pivot table fields based on values given in a reference tab. The pivot tables I am using are linked to an OLAP query and I can not seem to find a way to get the data to pull from cells in another tab. Do you know how I can update the cells in the reference tab...

Greetings everyone, Upon coming across this very helpful forum, I came across a post that up-until now has been extremely helpful. The link to the thread can be found here. The project that I have been given at work was to create a user form that has dependent combo boxes that will be used to...

I am working on a vba program in excel 2010. I have figured out how to create a own mouse right click menu, when clicking on a cell. But there still pops up a second right click menu, which shows some formatting icons. What do I need to do, so that my own right click menu is shown, but the...

I have got everything in place, it all works albeit sometimes slowly, I know I have inefficiencies in the VBA, but would this slow down the length of time it takes to open the file, or am I just impatient ? as for timing it takes about 15 seconds, I have several pieces of code across 4 modules...