P
PMF
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
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