VB.NET insert row in Excel XP

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

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.
 
Im not sure if this is what you are looking for but try:

Sub try()
ActiveCell.EntireRow.Insert

End Sub
 
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
 
Back
Top