Log in

View Full Version : Rick Rothstein's Corner


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