Siraj Samsudeen questions

• How to assign an array of values to a range in Excel VBA
• modify regex to capture Question and answer to include newlines
• 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

Siraj Samsudeen answers