Hi

I have the following problem:
I want to select a certain Range depending on the value of a variable

e.g.
I habe a variable called nr (current value = 1)
I want to replace:

Range("O1:O200").Select

with:

" Range [ Cells(1,(14+nr)) to Cells(200,(14+nr)) ]"

How can you wright that in VBA?

Mazo