Search results for query: *

I have this block of code that takes more than five seconds to run, appreciate any insights in making this work faster With Worksheets("Country-Product Report") If Worksheets("raw2").Range("H" & chrw) <> 0 Then shr = Worksheets("raw2").Range("E" & chrw) /...

I want to autofilter based on criteria that is not equal to what I select, can someone help me with the syntax, my code reads as follows, basically I have a combobox that has a list of numbers, if the user chooses one of those numbers, I want this code to work and filter sheet 3, row 3, column 3...

I have about 450 values that is in column A of Sheet1, Sheet2 and Sheet3. Can someone give me guidance on code needed to cycle through those 450 values and only keep the same value in that column in all three tabs and save as new file then move to do the same for the next value. Example: Sheet1...

I created a nice add-in that is used by my colleagues, I also created a two tab template that is used by my colleagues. Is there a way to put the template inside my add-in, so when the user selects that option, it would insert the two tab template inside the active workbook?

Add-in's in excel have some words that appear when you click on them inside the add-in menu option. Tools/Add-ins, does anyone know where that info is entered, I have created an ad-in, and I have no idea how to describe it.