Category Archives: VBA

Repeating a set of data

Posted on 21/01/2009 by dougaj4

The Microsoft Excel Blog has a discussion on ways of repeating a set of data, for instance making three copies of every row of a range of data.  I have written a simple UDF to do this job, and also extract … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | 1 Comment

Drawing in Excel 9 – Perspective Projection

Posted on 13/01/2009 by dougaj4

Previous post  Download PlotXYZ-xlsb.zip (XL 2007) Download PlotXYZ-xls.zip (XL 2003 and earlier) The drawing program presented in the previous post in this series has been modified to plot perspective projections of line drawings defined by 3D coordinates of line end points, … Continue reading →

Posted in Drawing, Excel, VBA | 3 Comments

Excel 2007 performance – Microsoft looking for feedback

Posted on 08/01/2009 by dougaj4

The latest post on the Microsoft Excel Blog is asking for comment on slow performance of Excel 2007, specifically related to VBA: Microsoft Excel Blog I encourage everyone to respond!

Posted in Excel, VBA | Tagged , , , | 1 Comment

Drawing in Excel 8 – scaling and trimming

Posted on 05/01/2009 by dougaj4

Previous Post – Drawing in Excel 7 Download PlotXY-xls.zip (XL 2003 and earlier) Download PlotXY-xlsb.zip (XL 2007) The previous post presented VBA routines to plot drawings in Excel from a series of coordinates, a list of connected points, and a … Continue reading →

Posted in Drawing, Excel, VBA | Tagged , , , , | 3 Comments

Significant Figures

Posted on 28/12/2008 by dougaj4

Excel does not provide any built in functions to round values to a specified number of significant figures.  The UDF below, recently posted at the Eng-Tips forum, will do the job: Public Function sigfig(my_num, digits) As Double Dim num_places As Integer … Continue reading →

Posted in Excel, Maths, UDFs, VBA | Tagged , , | 5 Comments