Dim ws As Worksheet
With Application
.ScreenUpdating = False
Set ws = Worksheets.Add
'do your computations
'you can also hide the sheet but it may not be necessary
.DisplayAlerts = False
ws.Delete
.DisplayAlerts = True
.ScreenUpdating = True
End With

--

Vasant


ws.Visible = xlSheetHidden

"P. Dileepan" wrote in message
...
Hi,

[1] I am adding a temporary worksheet in my code to setup
data and run a regression command. I want this operation
to be NOT visible to the user. How can I hide the
comopuations taking place in a sheet?

[2] After getting all the results I need, I want to
delete the sheet without having to confirm that I do want
to delete the sheet. I don't know how to do this.

Please help.

-- Dileepan