Search results for query: *

Thanks for the replies, screen updating I have it already set to false prior to this step. I was thinking that the copy and paste cell by cell was maybe slowing things down, but my skills in VBA are not advanced enough to do anything else.

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 discovered that my problem is numbers are appearing as text in my worksheet in that column

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

Thanks for the reply, I got this piece of code from Ron De Bruin site, I think something like this is what I need, I just not sure how to modify it. I could list my 450 values on the sheet and proceed from there. Each of the three sheet will have all 450 values, is it a problem if one of the...

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

That's good if you wanted to distribute the add-in and the template separately, but I want to bundle them together, so the template sheets are within my add-in. Is that possible? Thanks for your prompt reply! Mike

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?

Awesome, that is exactly what I was looking for, I was confused with the COM piece. Thanks a lot!!!

Hi Prashant, How do you code a COM, what tools do you need, is it just a class module in VBA? Thanks

Thanks for the reply, I click on automation and it lista everything, by choosing COM here br browsing, how will that help in typing in a description for the add-in. I am a little confused as to how to proceed.

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.