Peter Albert

Peter Albert has asked 55 questions and find answers to 58 problems.

Stats

About

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

Contact me at [email protected]

Peter Albert questions

Keep only numbers in a string / remove all non-numbers
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

Peter Albert answers

VBA converts string "12.00" to 1200 instead of 12.00. This happens only on EU regional setting and not US settings
VBA what is the longest allowed name for a function or procedure
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