Hello again,

I am very very novice but Dave Peterson has been showing me how
usefull VBA can be!
Therefore I have another question which I haven't been able Google.

The case:
How can I "run" through a column from A5 eg till the the last value in
that column.

and multiply B5 till the end-row, C5 till the end-row,....till F
with an HLOOKUP-value performed on the A5-cell.

So:
for A5, B5 becomes: the initial B5-value * Hlookup(A5,$B$1:$D$2),2,0),
C5becomes: C5-value * Hlookup(A5,$B$1:$D$2),2,0),...till F5
for A6,B6 becomes: the initial B6-value * Hlookup(A6,$B$1:$D$2),2,0),
C6becomes: C6-value * Hlookup(A6,$B$1:$D$2),2,0).... till F6
....
etc till the end of column A.

The B till F C columns do not need the formulas, only the multiplied
value.

I am sorry for the "messy" explanation, I hope you can help me,
Jen