Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill Series with Step
Hi,
I have the following code (found it in this group): Sub FillSeries() ActiveCell.Value = Range("A1").Value ActiveCell.DataSeries Rowcol:=xlColumns, Type:=xlLinear, _ Step:=Range("F2"), Stop:=Range("A50") End Sub A1= Start value A50= Stop value (last cell) F2= Step value But it only works for a linear data set... I want to copy each fifth (or another step value) value in a column to a second column. Any idea? Thanks for any help! Anders |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Drop Down List with Step by Step Instructions for 2007 | Excel Worksheet Functions | |||
Fill Series Dates: not letting me change the series from year to m | Excel Discussion (Misc queries) | |||
using Fill, series...how set STEP? | Excel Worksheet Functions | |||
Edit Fill Series - How do I fill using minute increments | Excel Discussion (Misc queries) | |||
I need step by step instructions to create a macro for 10 imbedde. | Excel Worksheet Functions |