I would like the macro to copy a static range and paste it in spesific
rows depending on counter-formulas.

I have one counter in cell av1, at the time giving the result 331.

So for pasting in one cell, I change the recorded VBA-string:
Range("AV331").Select

into the following that works fine:
Range("AV" & Range("Av1").Value).Select

My problem is that I also have a counter in aw1, at the time giving
the result 333. So what I want to do is to paste in a range, not in a
single cell:
Range("AV331:AV333").Select

How do I do this? Tried:
Range("AV" & Range("Av1").Value:"AV" & Range("Av1").Value).Select

but did not work. Any ideas?

Brgds,
Harald