automatic calculation within a range

hello guys,

i need to do an automatic calculation as follow
column A: from A1 to A200 > capacity from 1 to 10 i.e.
column B: from B1 to B200> automatic calculation which is B1=A1xD1/$E$1
column D: from D1 to D200 > value length from 0.0 to 5.0 i.e.
one value in E1

what I want is be able to calculate automatically what is in the column B when I put all the value i need in the other columns.

could you help me on that one. I use excel XP and VBA.

Thanks a lot, it'a for my thesis i am stuck since a couple oif days!!!!! :ehh:

chat51.