Test or check if sheet exists

Some folk dislike this approach because of an “inappropriate” use of error handling, but I think it’s considered acceptable in VBA… An alternative approach is to loop though all the sheets until you find a match. Function WorksheetExists(shtName As String, Optional wb As Workbook) As Boolean Dim sht As Worksheet If wb Is Nothing Then … Read more

Correct Bash and shell script variable capitalization

By convention, environment variables (PAGER, EDITOR, …) and internal shell variables (SHELL, BASH_VERSION, …) are capitalized. All other variable names should be lower case. Remember that variable names are case-sensitive; this convention avoids accidentally overriding environmental and internal variables. Keeping to this convention, you can rest assured that you don’t need to know every environment … Read more