Microsoft Software

Recent Answers

2013-06-19 Excel - Excel PROTECTED WORKSHEETS & ALLOWABLE ACTIONS:

William,    I understand you to say, that if you want to spellcheck a sheet and it is hidden, then you get an error.  So this code will unhide such a sheet, process it, then hide it again      Sub spell_check_allsheets()

2013-06-18 Microsoft Word - My Pictures folder Office 2007:

It is indeed an annoyance, and is discussed on various sites - for instance, http://social.technet.microsoft.com/Forums/windows/en-US/dd01ec44-9fe2-4426-9d0b

2013-06-18 Excel - Need to automatically copy last row 52 times....:

Hello, please upload the file from http://programarexcel.blogspot.com.ar/p/contacto.    In http://programarexcel.blogspot.com examples can download free excel macros programmed in VBA, the maros can download

2013-06-18 Excel - VBA Sort and Delete:

This assumes column D is available (D5:D15, anyway)    Sub RemoveDups()      Application.Calculation = xlCalculationManual      On Error GoTo Done      Range("D5:D15").FormulaR1C1 = "=if(countif(rc1:r15c1

2013-06-18 Excel - VBA Sort and Delete:

Sorry - more questions.  Look for dups in B & C as well or just A?  Is A5:C15 the result of the cells AFTER the paste or before (meaning you want to paste to A16).  After the paste, is the range surrounded