1. Announcement:
    Social Network Buttons
    Excel Fox (Administrator)
    07-27-2011
    Views:
    31,190
Page 1 of 2 12 LastLast
Threads 1 to 20 of 36

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. UDF (user defined function) replacement for Excel's DATEDIF function

    Started by Rick Rothstein, 02-27-2012 10:52 PM
    2 Pages •
    1 2
    datedif, udf, vba
    • Replies: 10
    • Views: 2,220
    ProspectiveCounselor
    05-15-2013, 01:07 AM Go to last post

  2. LookUp Value and Concatenate All Found Results

    Started by Rick Rothstein, 03-27-2012 01:27 AM
    3 Pages •
    1 2 3
    concatenate, lookup, mulle, udf
    • Replies: 20
    • Views: 5,809
    Admin
    05-08-2013, 09:45 AM Go to last post

  3. VBA Versions of my "Get Field" and "Get Reverse Field" formulas

    Started by Rick Rothstein, 05-01-2013 07:53 PM
    • Replies: 0
    • Views: 100
    Rick Rothstein
    05-01-2013, 07:53 PM Go to last post

  4. Redistribute a Delimited Column Of Data into Separate Rows (Keeping Other Data As Is)

    Started by Rick Rothstein, 05-22-2012 11:12 PM
    • Replies: 6
    • Views: 2,260
    snb
    05-01-2013, 02:59 AM Go to last post

  5. Overcoming Limitations in the VBA SpecialCells Function

    Started by Rick Rothstein, 04-26-2013 01:17 AM
    • Replies: 0
    • Views: 185
    Rick Rothstein
    04-26-2013, 01:17 AM Go to last post

  6. Convert a (Possibly) Very Large Positive Decimal Number to Any Base (Up To 36)

    Started by Rick Rothstein, 03-31-2013 06:43 AM
    int division back slash
    • Replies: 4
    • Views: 420
    Excel Fox
    04-22-2013, 05:22 PM Go to last post

  7. Convert a Number in Any Base (Up To 36) to a (Very Large) Positive Decimal Number

    Started by Rick Rothstein, 06-26-2012 10:02 PM
    base, binary, conversion, decimal, hex, vba
    • Replies: 3
    • Views: 841
    Rick Rothstein
    03-31-2013, 06:48 AM Go to last post

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

    Started by Rick Rothstein, 03-23-2012 06:10 AM
    color, conditional, formatting, functions, vba 1 Attachment(s)
    • Replies: 5
    • Views: 6,205
    rishidoshi
    03-15-2013, 10:01 AM Go to last post

  9. Flexible Concatenation Function

    Started by Rick Rothstein, 02-19-2012 10:52 PM
    3 Pages •
    1 2 3
    concatenate, join, range, vba
    • Replies: 22
    • Views: 4,037
    snb
    02-17-2013, 03:28 AM Go to last post

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

    Started by Rick Rothstein, 03-09-2012 01:26 AM
    find, function, match, pattern, substring, udf
    • Replies: 2
    • Views: 2,067
    aimhigh85
    02-10-2013, 05:49 AM Go to last post

  11. A Blinking Christmas Tree

    Started by Rick Rothstein, 12-16-2012 09:00 AM
    1 Attachment(s)
    • Replies: 4
    • Views: 763
    Rick Rothstein
    12-23-2012, 12:43 AM Go to last post

  12. Sorry about my absence from this forum of late...

    Started by Rick Rothstein, 12-08-2012 01:09 AM
    • Replies: 3
    • Views: 447
    Rick Rothstein
    12-11-2012, 09:02 PM Go to last post

  13. Replacement for the Flawed UsedRange Property

    Started by Rick Rothstein, 04-11-2012 02:00 AM
    • Replies: 9
    • Views: 2,049
    Admin
    12-04-2012, 07:39 PM Go to last post

  14. Free U.S. ZIP CODE Database...

    Started by Rick Rothstein, 05-25-2012 10:57 PM
    • Replies: 2
    • Views: 2,994
    Taylor Hawkes
    12-02-2012, 08:08 AM Go to last post

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

    Started by Rick Rothstein, 05-05-2012 01:01 AM
    • Replies: 2
    • Views: 1,099
    Rick Rothstein
    11-21-2012, 04:46 AM Go to last post

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

    Started by Rick Rothstein, 04-06-2012 08:58 AM
    cent, dollar, number, rupees, spell, text, vba, words
    • Replies: 5
    • Views: 1,440
    snb
    11-06-2012, 07:16 PM Go to last post

  17. Excel Number Format: Indian Style Comma Separation

    Started by Rick Rothstein, 04-12-2012 11:38 PM
    • Replies: 2
    • Views: 5,882
    Rick Rothstein
    11-05-2012, 07:40 PM Go to last post

  18. FindWord - Find A (Possibly Listed) Word, As A Word, Not Embedded Within Another Word

    Started by Rick Rothstein, 10-12-2012 02:00 AM
    • Replies: 1
    • Views: 670
    Rick Rothstein
    10-16-2012, 02:23 PM Go to last post

  19. FORMATTED Flexible Concatenation Function

    Started by Rick Rothstein, 09-25-2012 11:22 PM
    • Replies: 1
    • Views: 659
    chathuraa
    10-14-2012, 04:18 PM Go to last post

  20. Split Function That Ignores Delimiters Located Inside Quote Marks

    Started by Rick Rothstein, 09-15-2012 06:55 AM
    split, vba
    • Replies: 4
    • Views: 1,575
    Rick Rothstein
    09-21-2012, 10:57 PM Go to last post
Page 1 of 2 12 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