![]() I would be inclined to use the get_Range() method of the Worksheet object since that usually works in a more predictable manner. When I tried that I was getting cells inserted after the used range of cells, not where I wanted. You could be running into trouble because you're only specifying row numbers in the WorkSheet.Cells property and not column names. Secondly, I don't think your Excel.Range object is being set up properly. And not where I'd even imagine it to get inserted- Row 2, column 19.įirst of all, I don't see where you are setting your xlWorksheet but that would be the first place I'd check to see why your cells are being inserted on the wrong sheet. However, my Insert gets inserted into the wrong worksheet, hah. ![]() MisValue, misValue, misValue, misValue, misValue) Įxcel.Range r = xlWorkSheet.Range, xlWorkSheet.Cells] MisValue, misValue, misValue, misValue, misValue, misValue, So how would I insert a row between 21 and 22, after printing 3 items out?Įdit So here's what I have: (template, misValue, misValue, misValue, Obviously, most purchases will have more than 3 items, though. On the template, there's only room for 3 rows worth of items, then the template shows the Total. I have an Excel '07 Template file for a purchase order.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |