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

length(find(myVector==Inf))

skip to main |
skip to sidebar
## Tuesday, January 29, 2008

###
count how many Inf's are in a vector

###
ckeck if a variable exist

## Tuesday, January 8, 2008

###
Delete sheets without confirmation prompts using VBA in Excel

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

## other nice blogs

## Labels

just another blog. here you'll find my experiences with Matlab/Simulink, vba, LaTeX and Mac OS X.

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

length(find(myVector==Inf))

Posted by otmezger at 9:11 AM 2 comments Links to this post

Labels: matlab

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

Posted by otmezger at 7:20 AM 0 comments Links to this post

Labels: matlab

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

Posted by otmezger at 2:41 PM 0 comments Links to this post

Labels: vba

Subscribe to:
Posts (Atom)

- announcements (1)
- best practice (1)
- carpetplot (3)
- cell array (1)
- colorbar (1)
- debug (2)
- excel (5)
- firefox (3)
- fourier (1)
- gds (1)
- label (1)
- latex (4)
- m-lint (1)
- mac (6)
- mathworks webinars (3)
- matlab (56)
- matlab GUI (2)
- matlab import (1)
- matlab plots (17)
- matlab subplots (2)
- matlab-tutorials (4)
- other (2)
- simulink (10)
- speeding up code (2)
- svn (1)
- thermodynamics (2)
- vba (10)
- video tutorial (1)
- warning (1)