Tuesday, January 29, 2008

count how many Inf's are in a vector

the following command returns how many Inf's are in a vector

length(find(myVector==Inf))

ckeck if a variable exist

To ckeck if a variable in matlab exist, just use the function exist.

Tuesday, January 8, 2008

Delete sheets without confirmation prompts using VBA in Excel

Hi people,

i was searching for a way to delete a worksheet without confirmation prompt in vba and i found this link.
the code is listed here:


Sub DeleteSheet(strSheetName As String)
' deletes a sheet named strSheetName in the active workbook
Application.DisplayAlerts = False
Sheets(strSheetName).Delete
Application.DisplayAlerts = True
End Sub