strange error with the code vs worksheet

Office

Question:ActiveCell.FormulaR1C1 = _"" "" "" = IF (AND (MONTH(RC[-2]) = MONTH(R[1]C[-2]), YEAR(RC[-2]) = YEAR(R[1]C[-2])))"" "", text (RC-[2] "," ""dddd mmmm"" ") &" "(" "&" ""Yvonne"" & FIXED (SUMPRODUCT (-(MONTH(R3C10:R40C10) = MONTH(RC[-2])),-(YEAR(R3C10:R40C10) = YEAR(RC[-2])),--(R3C2:R40C2=""x""),(R3C6:R40C6)), 0) "&" "" ") (" "&" ""Jack"" & FIXED (SUMPRODUCT (-(MONTH(R3C10...Read More

Posted: 06 May 2012

Tags: strange error with the code vs worksheet strange error with the code worksheet

My icon for microsoft Security essentials on the task bar becomes orange after a certain time and I have to scan the computer to get the Green still almost every day

Malmware

Question:My icon microsoft Security Essentials on the taskbar retains what orange and I have to rescan the computer for new greenAnswer:With the kind permission of the forum users the ball and ahaap:You use CCleaner? Piriform, meant programmed for any reason to remove a part of the ESM history files and delete files that MSE checks to determine the last time, an analysis was conducted.Open the Applications...Read More

Posted: 18 Apr 2012

Tags: My icon for microsoft Security essentials on the task bar becomes orange after a certain time and I have to scan the computer to get the Green still almost every day icon for microsoft Security essentials the task bar becomes orange after certain time and have scan computer get Green still almost every day

How to value all cells in a named range

Office

Question:I have a list of spare parts in a column in MS excel 2007. some of these parts are assembled together to another assembly.I would like a link / highlight all of these elements in the column.Answer:Thank you again, even if your suggestion solved my problem in a large measure, I was looking for to select a replacement part that highlights all the parts Assembly and F5 is the otherwise autour...Read More

Posted: 17 Apr 2012

Tags: How to value all cells in a named range How value all cells named range

Choose the value of the cell of the range of cells

Office

Question:Hi allI have a column of values for each month, I would like to have a single cell (off the coast of the side) choice of the largest value in the column and show here.I need to report the largest tonnage for a date within a month.Column 1 = Date of the monthColumn 2 = crewColumn 3 = Tonnage produced for the crewColumn 4, end of month (say the cell "D31") indicates the value of tonnage in...Read More

Posted: 15 Apr 2012

Tags: Choose the value of the cell of the range of cells Choose the value cell range cells

Definition and copy of ranges in Excel

Office

Question:HelloAnswer:HelloTry this. I left the line to remove the columns commented on the note. If you are satisfied the code works properly the simply remove the apostrophePrivate Sub Update_Click()'============================================"PROCESS FEATURE CANDIDATE."'============================================Dim LastRow as longDST Dim worksheetSet dst = Sheets ("13 programme UX Support")With...Read More

Posted: 12 Apr 2012

Tags: Definition and copy of ranges in Excel Definition and copy ranges Excel