easy one

[MERKY]

this formula is part of a larger formula:

Range("D5:D" & x).Select

How can i replace the "5" to, x/2 add 1 using Visual Basic language

 

[eliW]

On 2002-05-02 04:43, MERKY wrote:
this formula is part of a larger formula:

Range("D5:D" & x).Select

How can i replace the "5" to, x/2 add 1 using Visual Basic language

If I understand your question:

x = 5
y = Int(x / 2) + 1
Range("D" & y, "D" & x).Select

Eli

 

[Ivan F Moala]

On 2002-05-02 04:43, MERKY wrote:
this formula is part of a larger formula:

Range("D5:D" & x).Select

How can i replace the "5" to, x/2 add 1 using Visual Basic language

If I undertand you correctly ?? then
Range("D" & (x2)+1 & ":D" & x).Select