View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eggle Eggle is offline
external usenet poster
 
Posts: 6
Default HowTo insert a blank row and move existing down

I have

Date C1 C2 C3 C4
10/3 256 212 456 18
10/2 12 98 77 45

I want

Date C1 C2 C3 C4
blank row here - I'll put my new data on this row
10/3 256 212 456 18
10/2 12 98 77 45

p.s. I'm a VS 2003 C# guy not VB, for example

using Excel;

Excel.Worksheet sheet = (Excel.Worksheet)book.Worksheets["Passenger"];
sheet.get_Range("A13", "L99").Clear();
sheet.get_Range("L2", "L4").ClearContents();
Excel.Range rngNow = sheet.get_Range("J9", Missing.Value);