You can just delete the sheet directly by using "Sheets(1).Delete" or
"Sheet1.Delete"



HTH,
JP

On Nov 13, 2:46 pm, wrote:


Hi.. could you please let me know how to tackle this problem using
something in the lines of

dim wsindex as integer
if wsindex = 1 then
'activate that sheet
end if

Thanks