easy one

MERKY · May 2nd, 2002, 05:43 AM

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 · May 2nd, 2002, 06:00 AM

Quote:

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 · May 2nd, 2002, 06:03 AM

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 2nd, 2002, 05:43 AM	#1
MERKY New Member Join Date: Apr 2002 Posts: 38	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