Siraj Samsudeen questions

• What is the pythonic way of writing a long if-else statement?
• vba are empty values treated as zeroes in equality comparison
• How to rank within category in Excel?
• Design of snapshots in a transactional database along with versioning of reference data
• VBA How to declare an array with elements with different datatype
• excel vba how to copy the value of multiple non-contiguous ranges into an array
• SQL Server: Can the same table exist in multiple schemas
• Difference between CreateObject("Excel.Application") .Workbooks.Open and just Workbooks.Open
• vba code refactoring - are there any tools to assist? [closed]

Siraj Samsudeen answers