| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill series macro with different steps
HI
I want to fill a sereis based on the first and last numbers in the selection, with the step set to linear interoplate between the first and last numbers. Does anyone suggest some VBA code that would help? This is the same as selecting two numbers with blanks in between and then doing Edit:fill:Series. Excel automatically works out the correct step. However, if I record a macro for this, the step doesn't is fixed to the step value I recorded it with. So it doesn't help if I want to do this many many times.... Cheers |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill Series Dates: not letting me change the series from year to m | Excel Discussion (Misc queries) | |||
| how can we hide the steps of macro running | Excel Discussion (Misc queries) | |||
| HOW TO USE FILL SERIES | New Users to Excel | |||
| Edit Fill Series - How do I fill using minute increments | Excel Discussion (Misc queries) | |||
| Complex Macro to perform an operation as it steps down cells? | Excel Worksheet Functions | |||
Threaded Mode
