Formula to find text and count it within an entire workbook I have a workbook where there is nothing consistent or any named ranges. I need to make a summary sheet and count everytime I have the word cable in the entire workbook in column B. I have tried different variations of countif, lookups and find but have not come up with a combination that works. My restraint is tha... 5 Apr 2010 23:56 sort range I'm sorry if this is a repost but I asked this question last week and now I can not find the question. It was odd because the same day I had seen a response but I look today and nothing, not even the question. I am using the following code in a Macro to sort my spreadsheet ... Range("A1:U700").Sort Key1:=Ran... 5 Apr 2010 11:38 IF for inverting true/false hello all !! i have this.... =OR(AND(T65-U65>=Q55*N11;L10=TRUE);(U55*Q56<=T55)) but for some formal reason i need it to give false when it's true and vice versa.. with this... if i am not wrong... =IF(OR(AND(T65-U65>=Q55*N11;L10=TRUE);(U55*Q56<=T55));FALSE;TRUE) am i right ?? tx !! paolo ... 5 Apr 2010 11:38 Run macro on selected sheets Hi I have a workbook with 103 sheets, I want a macro to run on 100 of the sheets. Here is the macro, can anyone help me with this? Sub ReconsileStockCard() Range("D3").Select ActiveCell.FormulaR1C1 = "=SUM(R[4]C[-2]:R[97]C[-2])" Range("D3").Copy Range("B7").PasteSpecial Paste:=xlPasteValues,... 5 Apr 2010 15:01 COM add-ins Is there a way via vba code to list the COM add-ins running in Excel? Bob ... 6 Apr 2010 10:49 Make a file save and close itself based on the value of a cell If Sheet1!A1's value is = 1, then I would like for the file to save and then close itself. Is this possible? Thanks in advance. Michael ... 5 Apr 2010 07:13 Hiding Rows Using IF Statement I would like to be able to hide a number of rows based on the response to a question.. The response to the question is a list box with either "yes" or "no" as the choices.. If the response = "no" then I would like to hide the next 3 rows, otherwise do nothing.. Is there a "hide" command of some sort that ... 4 Apr 2010 14:52 hisind rows with an if statement I would like to be able to hide a number of rows based on the response to a question.. The response to the question is a list box with either "yes" or "no" as the choices.. If the response = "no" then I would like to hide the next 3 rows, otherwise do nothing.. Is there a "hide" command of some sort that ... 4 Apr 2010 14:52 How to Combine Columns of Text - sounds easy I have two columns of text that I want to combine into a third column. The two columns of text may have blank cells mixed in with the text. These blank cells need to be ignored and not included in the combination. How do I combine the two columns into a single column? I have tried Range.Consolidate and Sele... 5 Apr 2010 10:30 Excel 2007 Custom ShortCut Keys I can override almost any Excel shortcut Key by using Application.OnKey key, Macroname For example, this uses the [CTRL+SHIFT+ 9 aka left/open parens "("] and overrides the built-in command to Unhides any hidden rows within the selection. Application.OnKey "+^9", "MyMacro" Now [CTRL+SHIFT+ (] runs MyMa... 4 Apr 2010 11:32