AnderWare Excel2k Macros

What is AnderWare Excel2k Macros?

This template contains a useful MS Excel2000 macro

CreateSeries

This macro was built and tested on Windows 2000 Professional(SP3) running Office 2000(SR1-SP3)

CreateSeries

Introduction

A macro(VBA) for creating series based on user input

Useful when you have a starting value in one cell and an ending value in another
and you want to fill the rows/column between them with numbers inbetween

Example - Columns

Before
1			3

Desired result
1	1,666666667	2,333333333	3

Example 2 - Rows

Before		Desired result
1		1
		1,666666667
		2,333333333
3		3

This macro requires some knowledge of working with macros in Excel.

Features

Choose between integer(whole numbers) and decimal series
Row or columnbased series

Usage

Start the macro contained in the Excel worksheet.
With the reference edit boxes select the start and end cell to create series in between.

Screenshots

Screenshot

Read Version History for more information on features and whats new in this release.

These macros may be distributed and used freely as long as it remains unaltered (including this text).
AnderWare Development takes no responsibility whats so ever for whatever this macro may cause to your computer/software/data. Always make backups of your data before using these macros