Peter Albert

Peter Albert has asked 57 questions and find answers to 59 problems.

Stats

About

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

Contact me at [email protected]

Peter Albert questions

Newtonsoft Json serialize a class where one of the properties is JSON [duplicate]
Hide add-in tabs from MS Office ribbon (esp. PowerPivot tab)
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

Peter Albert answers

VBA: Exit For Loop when row is empty
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)?