Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
added a range of data
I am working in VB.Net. I have a collection of objects that need to be
entered into a excel spreadsheet. Each object will contain three values, the values will be going into column A thru C. the number of objects is unknown. Here it is in suedo code: dim row as ???? = row 2 of the excel spreadsheet for each obj as MyObject in coll row.column["A"] obj.FirstValue row.column["B"] obj.SecondValue row.column["C"] obj.ThirdValue row = the next row in the excel spread sheet Next How do I do this in either VBA or VB.Net? I would prefer that the column not be absolute, because I need to do this type of thing in a number of places. Also, I will need to know what the last row was after the for each so that other data can be placed under it. Thanks for the help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtract a range from an added range | Excel Discussion (Misc queries) | |||
Can you dynamically expand the time range to the series data added | Charts and Charting in Excel | |||
seeking help on how to automatically shift an average range as new data is added | Excel Discussion (Misc queries) | |||
repost: seeking help on how to automatically shift an average range as new data is added | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) |