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. 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,245,825
    Brooke.Zammit
    10-31-2019, 07:00 AM Go to last post

  2. Test Whether A Point Is In A Polygon Or Not

    Started by Rick Rothstein, 11-11-2013 11:17 PM
    5 Pages •
    1 2 3 ... 5
    geometry, inside, point, polygon, udf, vba 5 Attachment(s)
    • Replies: 42
    • Views: 1,068,400
    DocAElstein
    06-17-2021, 04:26 PM Go to last post

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

    Started by Rick Rothstein, 05-22-2012 10:42 PM
    4 Pages •
    1 2 3 ... 4
    4 Attachment(s)
    • Replies: 34
    • Views: 264,657
    rpg1966
    03-13-2015, 02:26 PM 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,411
    Rick Rothstein
    05-11-2019, 08:22 PM Go to last post

  5. 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: 33,359
    bassem.dar
    03-07-2015, 09:47 PM Go to last post

  6. Delete One Row From A 2D Variant Array

    Started by Rick Rothstein, 02-11-2016 02:48 AM
    2 Pages •
    1 2
    • Replies: 18
    • Views: 764,505
    BigFastPanda
    02-23-2020, 03:10 PM Go to last post

  7. 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: 552,405
    Rick Rothstein
    12-20-2016, 09:47 AM Go to last post

  8. 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,520
    gembree
    10-21-2013, 07:11 PM Go to last post

  9. Swapping (Rearranging) Multiple Columns of Data

    Started by Rick Rothstein, 07-30-2012 09:23 AM
    2 Pages •
    1 2
    index function, rearrange columns, vba
    • Replies: 13
    • Views: 18,054
    mrmmickle1
    07-15-2014, 05:21 AM Go to last post

  10. A Neat "Go To Sheet" Selector

    Started by Rick Rothstein, 05-30-2014 10:38 PM
    2 Pages •
    1 2
    4 Attachment(s)
    • Replies: 12
    • Views: 35,795
    JohanRyman
    09-02-2014, 04:20 PM Go to last post

  11. 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,940
    ipi99
    08-06-2020, 02:44 PM Go to last post

  12. Replacement for the Flawed UsedRange Property

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

  13. Generalized Series Expansions (e.g. AB5-AB9 becomes AB5, AB6, AB7, AB8, AB9)

    Started by Rick Rothstein, 01-01-2014 11:17 PM
    • Replies: 8
    • Views: 7,226
    jcoeng
    06-21-2017, 01:59 PM Go to last post

  14. 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: 18,011
    Rick Rothstein
    08-24-2015, 10:58 PM Go to last post

  15. The Number of Years, Months and Days Between Two Dates

    Started by Rick Rothstein, 05-12-2012 11:43 PM
    • Replies: 7
    • Views: 5,737
    snb
    06-08-2012, 10:35 PM Go to last post

  16. Remove UserForm's TitleBar And Frame

    Started by Rick Rothstein, 08-28-2012 10:50 PM
    frame, title bar, userform, vba
    • Replies: 7
    • Views: 33,284
    Rick Rothstein
    06-04-2020, 04:48 AM Go to last post

  17. Spell a Date out in Words

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

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

    Started by Rick Rothstein, 05-05-2012 12:31 AM
    • Replies: 6
    • Views: 39,636
    rskhan7
    01-02-2020, 06:48 PM Go to last post

  19. Find the First or Last So Many Words in a Text String

    Started by Rick Rothstein, 06-19-2012 01:54 PM
    find, formula, text string, words
    • Replies: 6
    • Views: 6,997
    Rick Rothstein
    06-21-2012, 09:42 PM Go to last post

  20. Replace Cell References In Formulas With Their Actual Value

    Started by Rick Rothstein, 07-16-2013 12:42 AM
    • Replies: 6
    • Views: 4,817
    Rick Rothstein
    02-12-2014, 12:51 AM 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