Say that you enter a value *or* a formula in A11.
This will be the *value displayed* in the A1 to J1 array.

Say you enter a formula *or* a value in A10.
This will be the *interval* to repeat the value from A11 into the A1:J1
array.

Now, enter this formula in A1 and copy across to J1, *or further* if
necessary:

=(MOD(COLUMN(),$A$11)=0)*$A$10


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"LSB M" wrote in
message ...

I have 10 columns: A1:J1

I would like to deposit a value (actually, a formula) every "X"
interval. So if I specify "2", I would like to deposit this value
every "2" columns in the array A1:J1. If I enter "3", every 3 columns,
etc.

Would appreciate any help...


Thanks!


--
LSB M
------------------------------------------------------------------------
LSB M's Profile:
http://www.excelforum.com/member.php...o&userid=36258
View this thread: http://www.excelforum.com/showthread...hreadid=563534