-
January 11th, 2014, 07:11 AM
#1
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|