You are here:
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()
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
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
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
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