deleting specified worksheet from code
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
Re: deleting specified worksheet from code
Turn on Messages
Code:
oWB1.Application.DisplayAlerts = True