-
Search RAD Excel
-
-
Recent Posts
- Workbook_Open vs. Auto_Open
- My First Custom Ribbon Using Excel-DNA And Visual Studio
- Get Property Syntax Bug [VBA]
- My First C#.Net UDF Using Excel-DNA And Visual Studio
- Who Has My Workbook Open? [VBA]
- Excel Development Roadmap – Where Next?
- UK Has Its Pie And Eats It
- Getting A Handle On Userforms [VBA]
- Unwanted Worksheet Events? Maybe SpecialCells() Is To Blame!
- #REF! Means Your INDIRECT() Formula May Be Slow As A Dog
- VBA: Understanding ByVal In An ActiveX Textbox KeyPress Event Handler
- Minimize And Maximize Userform Across 32-bit and 64-bit Environments
- Stop MSForms.Frame Scrollbars From Resetting On Focus
- Deceptive Appearances: MSForms Textboxes And Comboboxes
- Error Accessing The System Registry
Recent Comments
- Colin Legg on Self Extending UDFs – Part 1
- KH on Self Extending UDFs – Part 1
- Colin Legg on Self Extending UDFs – Part 1
- KH on Self Extending UDFs – Part 1
- John on How To Calculate The Next IMM Date
- Diederik de Jonge on VBA: Determine All Precedent Cells – A Nice Example Of Recursion
- Alan on Excel Macro to Find and Calculate Precedents
- Lucho on My First Custom Ribbon Using Excel-DNA And Visual Studio
- Shefali Dubli on Using WorksheetFunction.VLookUp To Look Up A Date In VBA
- excel - Ensemble ArrayFormula à de nombreuses cellules Excel à l'aide de VBA on Working With Range.FormulaArray In VBA
- Scott J. on Is Your Cell Blank Or Empty?
- highandwild22 on Stop MSForms.Frame Scrollbars From Resetting On Focus
- Andrew Lockhart on Naughty Data Validation Lists
- BaconBucket on Determine the Office Edition in VBA
- Greg on How To Calculate The Next IMM Date
Categories
- .Net (8)
- General (5)
- Microsoft Office (80)
- Microsoft Excel (80)
- Microsoft SQL Server (4)
- Off Topic (1)
- Windows (1)
Archives
- December 2016 (1)
- November 2016 (1)
- October 2016 (1)
- September 2016 (1)
- July 2016 (2)
- June 2016 (1)
- May 2016 (1)
- March 2016 (1)
- February 2016 (1)
- December 2015 (1)
- October 2015 (1)
- September 2015 (1)
- August 2015 (2)
- July 2015 (1)
- May 2015 (1)
- April 2015 (2)
- March 2015 (1)
- February 2015 (1)
- January 2015 (1)
- December 2014 (2)
- October 2014 (1)
- September 2014 (1)
- August 2014 (2)
- July 2014 (1)
- June 2014 (2)
- May 2014 (3)
- April 2014 (1)
- March 2014 (1)
- February 2014 (3)
- January 2014 (2)
- December 2013 (1)
- November 2013 (1)
- October 2013 (1)
- September 2013 (2)
- July 2013 (1)
- June 2013 (4)
- May 2013 (1)
- April 2013 (1)
- March 2013 (2)
- February 2013 (2)
- January 2013 (2)
- December 2012 (2)
- November 2012 (2)
- October 2012 (3)
- September 2012 (1)
- August 2012 (4)
- July 2012 (3)
- June 2012 (1)
- May 2012 (3)
- April 2012 (3)
- March 2012 (6)
- February 2012 (2)
- January 2012 (1)
- December 2011 (2)
Tag Archives: Repair
Naughty Sorts
Continuing the theme of naughty code which can cause Excel XML corruption, let’s have a look at some code which sorts some data in a range but then causes XML errors when the file is saved and re-opened. Here’s my sheet: … Continue reading
Naughty Data Validation Lists
Data validation is a wonderful thing. I know it has its shortfalls (and I always hope for improvements in each Office release) but, nevertheless, I do use it a lot in my spreadsheets – particularly data validation lists. The source for a data validation list comes in … Continue reading
Posted in Microsoft Excel
Tagged Data Validation, Removed Feature, Repair, Unreadable content
2 Comments
RAD Excel 