PDA

View Full Version : Rick Rothstein's Corner



  1. FindAll function
  2. Flexible Concatenation Function
  3. Spell a Date out in Words
  4. Recommendation: Do not use the undocumented DATEDIF function
  5. UDF (user defined function) replacement for Excel's DATEDIF function
  6. Return individual page numbers from a list of pages and ranges (e.g., 1,5,9-12,20-18)
  7. Find a text substring that matches a given "pattern"
  8. Get Field from Delimited Text String
  9. Get "Reversed" Field from Delimited Text String
  10. Ordinal Suffix (i.e., "st", "nd", "rd" and "th")
  11. Get Displayed Cell Color (whether from Conditional Formatting or not)
  12. Do you know when Easter is this year?
  13. LookUp Value and Concatenate All Found Results
  14. Wrap Text On Spaces Up To A Maximum Number Of Characters Per Line
  15. Yet Another Number-To-Words Function (Sorry, US Style Only)
  16. Replacement for the Flawed UsedRange Property
  17. Excel Number Format: Indian Style Comma Separation
  18. Follow-up to "Excel Number Format: Indian Style Comma Separation"
  19. InStrExact - Find Location Of A Word, As A Word, Not Embedded Within Another Word
  20. Nth Such-And-Such Day Of The Month
  21. The Number of Years, Months and Days Between Two Dates
  22. Redistribute a Delimited Column Of Data into Separate Rows (Keeping Other Data As Is)
  23. Free U.S. ZIP CODE Database...
  24. Find the First or Last So Many Words in a Text String
  25. Convert a Number in Any Base (Up To 36) to a (Very Large) Positive Decimal Number
  26. Reversing a "First Middle Last" Name to "Last, First Middle" Name Format
  27. Swapping (Rearranging) Multiple Columns of Data
  28. Remove UserForm's TitleBar And Frame
  29. Split Function That Ignores Delimiters Located Inside Quote Marks
  30. FORMATTED Flexible Concatenation Function
  31. FindWord - Find A (Possibly Listed) Word, As A Word, Not Embedded Within Another Word
  32. A Blinking Christmas Tree
  33. Convert a (Possibly) Very Large Positive Decimal Number to Any Base (Up To 36)
  34. Overcoming Limitations in the VBA SpecialCells Function
  35. VBA Versions of my "Get Field" and "Get Reverse Field" formulas
  36. Replace Cell References In Formulas With Their Actual Value
  37. Breaking the rules for UDF's (User Defined Functions)
  38. Test Whether A Point Is In A Polygon Or Not
  39. Generalized Series Expansions (e.g. AB5-AB9 becomes AB5, AB6, AB7, AB8, AB9)
  40. How To React To The Cancel Button in a VB (not Application) InputBox
  41. A Neat "Go To Sheet" Selector
  42. VB's Randomize Function Should Be Run Only Once Per Session
  43. Thinking About Using VBA's IsNumeric Function? Read this first.
  44. Align Data In Groups Of Columns
  45. Highlight Words In One Column That Do Not Appear In A Second Column
  46. Delete One Row From A 2D Variant Array
  47. A Method To Store Workbook Settings...