Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a Range object in .Net
How do I programatically define a range?
I writing information to the upper left of a rectangle at cell "A4" and a range defined as: xlRange = xlSheet.Range("A4") Next I add information to cells by moving to the right one cell, until I am done a 'row' of data. Then I go back to the "A" column, row+1 and add data to more cells as follows: for i = 0 to 10 for j = 0 to 10 xlRange.Offset(i, j) = i.tostring() + ", " + j.tostring next j next i Once I am finished, I want to format the 'range' of cells I jusst worked on using a statement something like (this is where I need help) myRange.SetRange (xlRange, xlRange.offset(i,j)) 'myRange is ("A4:K11") * Office XP Professional * Windows XP Professional * .Net v. 1.1 Gary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Excel Object From C# | Excel Discussion (Misc queries) | |||
Creating a picture/object | Excel Discussion (Misc queries) | |||
Range object to Array object conversion | Excel Programming | |||
Range object to Array object conversion | Excel Programming | |||
Range object to Array object conversion | Excel Programming |