Thread: Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
kiat kiat is offline
external usenet poster
 
Posts: 34
Default Excel

To delete cell: Range("A2").delete
To delete row: Rows(2).delete

"Mah'd" wrote in message
...
Hi there

I am trying to insert data on the first column in a
sheet , this row named 'Name', i noticed somthing that the
cell after the header is empty and the inserted data
follow it , is there any way to eliminate this empty
cell , i am using ADO.net to insert data on the excel sheet

e.g
A b c
Name
[empty cell] - I want to eliminate this cell.
Data1
Data2
...
Datan