AnsweredAssumed Answered

vrf Excel R1C1 reference type

Question asked by lesord on Sep 10, 2005
Latest reply on Sep 10, 2005 by lesord
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML><HEAD><META http-equiv=Content-Type content="text/html; charset=iso-8859-1"><META content="MSHTML 6.00.2800.1498" name=GENERATOR><STYLE></STYLE></HEAD><BODY bgColor=#ffffff><DIV><FONT face=Arial size=2>Hi John</FONT></DIV><DIV><FONT face=Arial size=2>            the example below is an example procedure that will fill the range you stated on the active worksheet with random numbers</FONT></DIV><DIV><FONT face=Arial size=2></FONT> </DIV><DIV><FONT face=Arial size=2>Public Sub test()<BR>Dim myrange<BR>Set myrange = Range(Cells(2, 1), Cells(300, 1))<BR>'                      Range(Cells(StartRow, StartColumn), Cells(EndRow, EndColumn)).<BR>myrange.Formula = "=rand()"<BR>End Sub</FONT></DIV><DIV><FONT face=Arial size=2></FONT> </DIV><DIV><FONT face=Arial size=2>Les</FONT></DIV><BLOCKQUOTE style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">  <DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>  <DIV   style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>   <A title=jwing@psemc.com href="mailto:jwing@psemc.com">John Wing</A> </DIV>  <DIV style="FONT: 10pt arial"><B>To:</B> <A title=vrf@agilent.com   href="mailto:vrf@agilent.com">VRF</A> </DIV>  <DIV style="FONT: 10pt arial"><B>Sent:</B> Saturday, September 10, 2005 12:10   AM</DIV>  <DIV style="FONT: 10pt arial"><B>Subject:</B> [vrf] Excel R1C1 reference   type</DIV>  <DIV><BR></DIV>  <DIV><FONT face=Arial size=2>  <DIV><FONT face=Arial size=2><SPAN class=511030722-09092005>I'm trying to load   a record with various size arrays in it, into Excel. It would be easier to use   the R1C1 reference type in Excel.</SPAN></FONT></DIV>  <DIV><FONT face=Arial size=2><SPAN class=511030722-09092005>How do I write,   <FONT color=#ff0000>set range=sheet.range("A2:A300");</FONT> using R1C1   reference type ?</SPAN></FONT></DIV>  <DIV><FONT face=Arial size=2><SPAN   class=511030722-09092005></SPAN></FONT> </DIV>  <DIV><FONT face=Arial size=2><SPAN class=511030722-09092005>Thanks   </SPAN></FONT></DIV>  <DIV><FONT face=Arial size=2><SPAN   class=511030722-09092005>John</SPAN></FONT></DIV></FONT></DIV><BR></BLOCKQUOTE><BR>---<BR>You are currently subscribed to vrf as: rsb@soco.agilent.com<BR>To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".<BR>To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".<BR>To send messages to this mailing list,  email "vrf@agilent.com".  <BR>If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".<BR>Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".</BODY></HTML>  

Outcomes