Page 1 of 3 123 LastLast
Threads 1 to 20 of 47

Forum: Rick Rothstein's Corner

An Excel MVP and an excellent programmer, Rick has been an avid helper in online communities for Visual Basic and Excel VBA.

  1. VB's Randomize Function Should Be Run Only Once Per Session

    Started by Rick Rothstein, 03-27-2015 11:02 PM
    1 Attachment(s)
    • Replies: 1
    • Views: 5,151
    Excel Fox
    03-28-2015, 05:52 AM Go to last post

  2. Find a text substring that matches a given "pattern"

    Started by Rick Rothstein, 03-09-2012 01:56 AM
    find, function, match, pattern, substring, udf
    • Replies: 2
    • Views: 8,651
    aimhigh85
    02-10-2013, 06:19 AM Go to last post

  3. FindAll function

    Started by Rick Rothstein, 02-19-2012 02:54 AM
    find, findall, vba
    • Replies: 1
    • Views: 3,873
    snb
    06-12-2012, 02:37 AM Go to last post

  4. Flexible Concatenation Function

    Started by Rick Rothstein, 02-19-2012 11:22 PM
    3 Pages •
    1 2 3
    concatenate, join, range, vba
    • Replies: 23
    • Views: 1,107,186
    Rick Rothstein
    05-11-2019, 08:22 PM Go to last post

  5. Spell a Date out in Words

    Started by Rick Rothstein, 02-22-2012 11:13 PM
    • Replies: 6
    • Views: 6,155
    Rick Rothstein
    04-08-2012, 12:19 PM Go to last post

  6. Recommendation: Do not use the undocumented DATEDIF function

    Started by Rick Rothstein, 02-27-2012 10:36 PM
    • Replies: 4
    • Views: 24,066
    shg
    05-16-2015, 10:06 PM Go to last post

  7. UDF (user defined function) replacement for Excel's DATEDIF function

    Started by Rick Rothstein, 02-27-2012 11:22 PM
    3 Pages •
    1 2 3
    datedif, udf, vba
    • Replies: 21
    • Views: 32,553
    bassem.dar
    03-07-2015, 09:47 PM Go to last post

  8. Return individual page numbers from a list of pages and ranges (e.g., 1,5,9-12,20-18)

    Started by Rick Rothstein, 03-06-2012 03:55 AM
    multiple page, page, print, single page
    • Replies: 0
    • Views: 2,951
    Rick Rothstein
    03-06-2012, 03:55 AM Go to last post

  9. Get Field from Delimited Text String

    Started by Rick Rothstein, 03-15-2012 12:51 AM
    • Replies: 5
    • Views: 33,276
    Rick Rothstein
    01-05-2017, 01:24 AM Go to last post

  10. Get "Reversed" Field from Delimited Text String

    Started by Rick Rothstein, 03-16-2012 08:21 AM
    • Replies: 3
    • Views: 12,059
    JeffreyWeir
    02-22-2015, 09:01 AM Go to last post

  11. Ordinal Suffix (i.e., "st", "nd", "rd" and "th")

    Started by Rick Rothstein, 03-20-2012 03:46 AM
    • Replies: 0
    • Views: 11,638
    Rick Rothstein
    03-20-2012, 03:46 AM Go to last post

  12. Get Displayed Cell Color (whether from Conditional Formatting or not)

    Started by Rick Rothstein, 03-23-2012 05:40 AM
    2 Pages •
    1 2
    color, conditional, formatting, functions, vba 3 Attachment(s)
    • Replies: 14
    • Views: 372,293
    gembree
    10-21-2013, 07:11 PM Go to last post

  13. LookUp Value and Concatenate All Found Results

    Started by Rick Rothstein, 03-27-2012 12:57 AM
    5 Pages •
    1 2 3 ... 5
    concatenate, lookup, mulle, udf 8 Attachment(s)
    • Replies: 48
    • Views: 1,244,061
    Brooke.Zammit
    10-31-2019, 07:00 AM Go to last post

  14. Wrap Text On Spaces Up To A Maximum Number Of Characters Per Line

    Started by Rick Rothstein, 04-02-2012 02:12 PM
    2 Pages •
    1 2
    cell, character, line, range, text, wrap
    • Replies: 15
    • Views: 551,606
    Rick Rothstein
    12-20-2016, 09:47 AM Go to last post

  15. Yet Another Number-To-Words Function (Sorry, US Style Only)

    Started by Rick Rothstein, 04-06-2012 08:28 AM
    2 Pages •
    1 2
    cent, dollar, number, rupees, spell, text, vba, words 1 Attachment(s)
    • Replies: 10
    • Views: 688,437
    ipi99
    08-06-2020, 02:44 PM Go to last post

  16. Excel Number Format: Indian Style Comma Separation

    Started by Rick Rothstein, 04-12-2012 11:08 PM
    2 Attachment(s)
    • Replies: 6
    • Views: 53,840
    shajithm
    09-18-2013, 11:38 AM Go to last post

  17. Replacement for the Flawed UsedRange Property

    Started by Rick Rothstein, 04-11-2012 01:30 AM
    • Replies: 9
    • Views: 9,309
    Admin
    12-04-2012, 08:09 PM Go to last post

  18. Follow-up to "Excel Number Format: Indian Style Comma Separation"

    Started by Rick Rothstein, 04-14-2012 02:27 AM
    cell format, currency, format, indian, indian style, number format
    • Replies: 2
    • Views: 7,026
    Rick Rothstein
    04-14-2012, 10:46 PM Go to last post

  19. InStrExact - Find Location Of A Word, As A Word, Not Embedded Within Another Word

    Started by Rick Rothstein, 04-26-2012 10:26 AM
    case sensitive, extract, find, instr, location, match, search, vba, word
    • Replies: 7
    • Views: 17,733
    Rick Rothstein
    08-24-2015, 10:58 PM Go to last post

  20. Nth Such-And-Such Day Of The Month

    Started by Rick Rothstein, 05-05-2012 12:31 AM
    • Replies: 6
    • Views: 39,427
    rskhan7
    01-02-2020, 06:48 PM Go to last post
Page 1 of 3 123 LastLast

Forum Information and Options

Moderators of this Forum

Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 15 replies or 150 views
Hot thread with unread posts
More than 15 replies or 150 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in this thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules