AnsweredAssumed Answered

vrf Vee to Excel

Question asked by VRFuser on Aug 8, 2006
Create a variable for the array length.
Then put this variable in a FOR loop for number of rows.  Column is constant.



-----Original Message-----
From: jbizkitawg@netscape.net [mailto:jbizkitawg@netscape.net]
Sent: Tuesday, August 08, 2006 4:26 PM
To: VRF
Subject: [vrf] Vee to Excel

Howdy all!

I have an array of data that I want to output to Excel and I want to tell the spreadsheet to adjust the range based upon the number of data points in the array.  The number of points will differ so I can not :

"Set range = sheet.range("A1:A5")"

I am looking more for:

"Set range = sheet.range("A1:A(how ever many I need)

If I hard code the max number I need I will get a bunch of N/A's in my spreadsheet that I don't want to see.

Any thoughts?



---
You are currently subscribed to vrf as: Han.Tran@wdc.com To subscribe please send an email to: "vrf-request@lists.it.agilent.com"
with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list,  email "vrf@agilent.com". 
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".


---
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list,  email "vrf@agilent.com". 
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".

Outcomes