AnsweredAssumed Answered

Exporting to Excel

Question asked by jdurec on Jul 11, 2011
Latest reply on Oct 18, 2011 by Udaybn

Like • Show 0 Likes0
Comment • 3

Does anyone know how I could use a variable in an Assignment formula-object? I am trying to export data to an Excel file and currently have it set up so that the data can fill cells A5:A105, but then I get a lot of N/A's in the empty cells. If I could make the end a variable I believe that it would solve the problem.

----> I attached what I have so far (setup and fill file)

Attachments

toexcel.bmp1.5 MB

No one else has this question

Outcomes

3 Replies

MichaelWatts Jul 12, 2011 1:36 AM
Mark Correct
Correct Answer
Yes, you should be able to make your range a variable - it is just text being passed into the Range method. You might also want to look at the language reference for range as there are several options for use e.g. you can pass it a couple of Cell objects instead of text. Either way you should be able to construct the actual range you need from the size of the array you pass in.

Mike
Like • Show 0 Likes0
Actions
jdurec Jul 12, 2011 7:04 AM
Mark Correct
Correct Answer
Thanks, but I know that I can (have tried unsuccessfully to construct various ways to do this) I just have not found a way to actually DO it.
Like • Show 0 Likes0
Actions
Udaybn Oct 18, 2011 2:35 AM
Mark Correct
Correct Answer
In the Excel --> Navigation, you will find a cellAbsolute function (the help text says "cellAbsolute returns the address of a cell given absolute coordinates where X is the
column and Y is the row"). You can use this change your range, perhaps.
Like • Show 0 Likes0
Actions

Exporting to Excel

Attachments

Outcomes

Related Content

Recommended Content