I am a supporter of
St. Joseph's hospice.
 If you find this site useful or if it helped you, consider a small donation to
St. Joseph's, please.

Information on
St. Joseph's

JustGiving - Sponsor me now!

 

sbVector

Excel © lacks a worksheet function "VECTOR(start,increment)" which creates a constant vector like 1, 3, 5, 7 (if start = 1 and increment = 2).

All worksheet function "tricks" like =ROW(INDIRECT("1:3")) have severe drawbacks of being volatile (they are recalculated each time you hit F9) and of depending on all cells in the referred rows.

A user-defined function like sbVector can help here. Please notice that it needs to be entered as an array formula (with CTRL + SHIFT + ENTER, not only with ENTER) into the desired target range.

My tiny Excel add-in Sulprobil.xll also offers a function sbVector. Its parameters are slightly different.

sbVector_01_Screen

If you are interested in downloading a 18 KB Excel 2010 © sample file which contains the function shown here, go to my Download page, please.

sbVector_01_Code
sbVector_02_Code
Sulprobil   Get it done   Contact   Disclaimer   Download