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: VBA
A Custom Tab RibbonX Template Which Handles State Loss
The first few times you want to customise the Excel ribbon you’ll find yourself scouring the internet and cobbling together bits and pieces from different sites to get the result you want. For this post I’ve created a template in … Continue reading
Posted in Microsoft Excel
Tagged Custom Tab, CustomUI Editor, ProtectionMode, RibbonX, Ron De Bruin, State Loss, UserInterfaceOnly, VBA
2 Comments
Count Distinct Or Unique Values – VBA UDF
A handful of posts ago I looked at some FREQUENCY() formulae which could give a count of distinct or unique values in a given column. The formulae became quite complicated and slow – particularly when dealing with mixed data types – … Continue reading
Posted in Microsoft Excel, Microsoft Office
Tagged Array, blank, Charles Williams, Collection, COUNTDISTINCT, COUNTUNIQUE, CreateObject, Dictionary, Distinct Count, empty, Frequency, Microsoft Scripting Runtime, New, scrrun.dll, Static, UDF, Unique Count, UsedRange, User Defined Function, VBA
6 Comments
VBA: What Type Are Your Constants?
In the previous post we saw a common mistake when declaring VBA variables and used the Locals window to show that variables are Variant types unless you specify otherwise by using: As Type in the declaration, eg. Dim strHello As String A type … Continue reading
Posted in Microsoft Excel, Microsoft Office
Tagged Compile Error, Constant, DefType, Locals window, Syntax Error, Type, Type Declaration Character, Variable, VBA
3 Comments
A Common Mistake When Declaring Variables In VBA
For today’s post I’d like you to imagine that you’re an up and coming VBA programmer who is starting to feel at home with the IDE and language. You’ve read about some VBA best practices which has made you aware of the … Continue reading
Posted in .Net, Microsoft Excel, Microsoft Office, VB .Net
Tagged Declare, Dim, Locals window, Option Explicit, Type, Variable, VBA
10 Comments
Phantom Breakpoints
I had a horrific Excel 2003 crash today. When I restarted Excel and opened any workbooks – including locked xla’s – which had been open during the crash, I found that they were riddled with phantom breakpoints. I’ve seen the occasional phantom breakpoint before, but … Continue reading
Posted in Microsoft Excel, Microsoft Office
Tagged code execution has been interrupted, Phantom Breakpoint, VBA
4 Comments
Determine the Office Edition in VBA
A few years ago a user asked how to use VBA to determine the edition of the active session of Office. I’m not sure why this would be useful (perhaps to show as information on a userform?) but I duly obliged … Continue reading
Posted in Microsoft Excel, Microsoft Office
Tagged Excel 2013, GUID, Office Edition, ProductCode, VBA, Version
3 Comments
Deleting Rows With VBA
A few years ago I posted a series of VBA samples on a forum which outlined different ways to delete rows in an efficient manner. The series proved to be very popular and, since that forum is now in decline, I’m going to resurrect those notes on here. The … Continue reading
Posted in Microsoft Excel, Microsoft Office
Tagged 8192 Non Contiguous Cells, Cannot use that command on overlapping selections, Count overflow error, delete rows, Excel VBA delete rows, Range.Autofilter, Range.ColumnDifferences, Range.Find, specialcells, VBA, VBA delete rows, VBA Delete Rows If
15 Comments