VB.NET insert row in Excel XP
Hi,
I am trying to insert a whole row and shift the data down in a spreadsheet. I am using VB.NET and have all the references to office and Excel in my project. I keep getting error when I try this. oSheet.Range("A" & 7,"A" & 8).insert() or osheet.Range("A" & 7,"A" & 8).select() with oXl.Selection osheet.rows.entireselection.insert() or a bunch of other combinations as well The error I get is a fatal one that says cannot move cells down if they are not empty and I have tried empty spreadsheets as well. Thanks, PS please forgive an syntax errors I made. |
VB.NET insert row in Excel XP
Im not sure if this is what you are looking for but try:
Sub try() ActiveCell.EntireRow.Insert End Sub -----Original Message----- Hi, I am trying to insert a whole row and shift the data down in a spreadsheet. I am using VB.NET and have all the references to office and Excel in my project. I keep getting error when I try this. oSheet.Range("A" & 7,"A" & 8).insert() or osheet.Range("A" & 7,"A" & 8).select() with oXl.Selection osheet.rows.entireselection.insert() or a bunch of other combinations as well The error I get is a fatal one that says cannot move cells down if they are not empty and I have tried empty spreadsheets as well. Thanks, PS please forgive an syntax errors I made. . |
VB.NET insert row in Excel XP
ActiveCell.EntireRow.Insert
ActiveCell is not valid in my vb.bet applicaion is there suppose to be a way to initialize it. I usually select a cell using a workSeet variable called osheet. So I can say osheet.cells(3,4).whatever I am doing. But if I use the osheet.cells or osheet.range and the select the app blows up. Thanks, Ben -----Original Message----- Im not sure if this is what you are looking for but try: Sub try() ActiveCell.EntireRow.Insert End Sub -----Original Message----- Hi, I am trying to insert a whole row and shift the data down in a spreadsheet. I am using VB.NET and have all the references to office and Excel in my project. I keep getting error when I try this. oSheet.Range("A" & 7,"A" & 8).insert() or osheet.Range("A" & 7,"A" & 8).select() with oXl.Selection osheet.rows.entireselection.insert() or a bunch of other combinations as well The error I get is a fatal one that says cannot move cells down if they are not empty and I have tried empty spreadsheets as well. Thanks, PS please forgive an syntax errors I made. . . |
VB.NET insert row in Excel XP
oSheet.Range("A7").EntireRow.insert
Will insert a single row. -- Regards, Tom Ogilvy Ben wrote in message ... Hi, I am trying to insert a whole row and shift the data down in a spreadsheet. I am using VB.NET and have all the references to office and Excel in my project. I keep getting error when I try this. oSheet.Range("A" & 7,"A" & 8).insert() or osheet.Range("A" & 7,"A" & 8).select() with oXl.Selection osheet.rows.entireselection.insert() or a bunch of other combinations as well The error I get is a fatal one that says cannot move cells down if they are not empty and I have tried empty spreadsheets as well. Thanks, PS please forgive an syntax errors I made. |
All times are GMT +1. The time now is 10:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com