Monthly Archives: July 2012

VBA Auto Data Tips

Auto data tips are a very handy feature when you’re debugging VBA code. You may have noticed that when you’re stepping through code, if you hover your mouse over, for example, a property, then you get a pop-up window showing its value. … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , | 5 Comments

Microsoft Office 2013 Public Preview

Microsoft announced  a public preview for the new Office today. The information on Excel can be found here. The preview version can be downloaded and installed alongside your existing version of Office 2003, 2007 or 2010. I can’t wait to … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , | 1 Comment

Putting Numbers In A Random Order In VBA

The following type of question comes up on the online forums very frequently: Using VBA I would like to have an array holding random numbers between 1 and 10 without duplicates. The words to pick up on are ‘without duplicates’: the numbers … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , , , | 3 Comments