Peter Albert

Peter Albert has asked 54 questions and find answers to 56 problems.

Stats

About

Consultant, trainer and developer, specialized in Excel, Access, SQL

Contact me at [email protected]

Peter Albert questions

Conditional compilation based on Excel version
Deploy project with same code base but different content to multiple sites
Use remaining space equally for n-columns
Loading of references in EF7
Serialize object to JSON that already contains one JSON property
How to properly rename CodeModule of ThisWorksheet
Add/Modify/delete calculated column formula in Excel Listobject/Table via VBA
Combine RxJS operators into new operator using TypeScript
How to programmatically change conditional compilation properties of a VBA project
How can I reference a cell's value in PowerQuery

Peter Albert answers

Excel sort numbers with letter prefix
Macro to delete a checkbox from a certain cell
How do I transpose a column into a row in Excel
Global variable declaration from class module
Working with time DURATION, not time of day
How to sort table using function/equation only
In Excel, is there an early opt out AND/OR functions (Short Circuit Evaluation)?
Getting return without gosub in my own function in vba
Prevent automatic format change from general to e.g. percentage
Excel VBA Global error handling