hi there,
place 15 in B1
select B1 and right click and select copy
select the other range A1:A100
right click and select paste special
check off add
ok

__________________
Dave
Please read the Forum Rules before posting!