Ron Rosenfeld

Ron Rosenfeld has asked 7 questions and find answers to 66 problems.

Stats

About

Ron Rosenfeld questions

Wrong Excel Window in Focus after Workbook_Open
WorksheetFunction.Transpose changes data type
CallByName Unexpected results if argument is Variant array set to cell range

Ron Rosenfeld answers

Excel: Inconsistent results of CountIf() on string with tilde
Find and Replace only values in Excel (not within formulas)
Nested strings for text(,format) conversion
Combining TEXTSPLIT with BYROW to return a spilled array [duplicate]
Deleting the first character of all the words starting with specific letters except for the first word in Excel
VBA - Remove Seconds from NOW function
Converting cell values to snake_case
How can I bold a part of a text that contains a formula?
Copy relative formula in excel with VBA
Most Frequent Words in List