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
-----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.

.

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.

.

.

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.