i am having total of 4 sheets of which sheet 1 & sheet 4 r compulsory
i am using datatable to fill the sheet with data
if dt1.rows.count<>0
-- write data to excel cells
else
oWB1.Application.DisplayAlerts = False
oWB1.Sheets("ABC").Delete
oWB1.Application.DisplayAlerts = True
end if

if dt2.rows.count<>0
-- write data to excel cells
else
oWB1.Application.DisplayAlerts = False
oWB1.Sheets("XYZ").Delete
oWB1.Application.DisplayAlerts = True
end if

i get error when it goes to else part of dt1 ie on the line
oWB1.Sheets("ABC").Delete

but if dt2 count is 0 the else part gets executed sucessfully ie the sheet 3 gets deleted

error
Public member 'Worksheets' on type 'Worksheet' not found