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. Do you know when Easter is this year?

    Started by Rick Rothstein, 03-24-2012 11:35 PM
    calculation, easter, vba
    • Replies: 3
    • Views: 19,568
    Willy Vanhaelen
    08-01-2021, 08:23 PM Go to last post

  2. A Method To Store Workbook Settings...

    Started by Rick Rothstein, 07-07-2021 06:43 AM
    • Replies: 0
    • Views: 2,572
    Rick Rothstein
    07-07-2021, 06:43 AM Go to last post

  3. 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,070,509
    DocAElstein
    06-17-2021, 04:26 PM Go to last post

  4. Thinking About Using VBA's IsNumeric Function? Read this first.

    Started by Rick Rothstein, 03-29-2015 02:28 PM
    1 Attachment(s)
    • Replies: 3
    • Views: 12,603
    DocAElstein
    03-24-2021, 02:29 PM Go to last post

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

  6. 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,477
    Rick Rothstein
    06-04-2020, 04:48 AM Go to last post

  7. 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: 765,114
    BigFastPanda
    02-23-2020, 03:10 PM Go to last post

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

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

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

  10. 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,610
    Rick Rothstein
    05-11-2019, 08:22 PM Go to last post

  11. How To React To The Cancel Button in a VB (not Application) InputBox

    Started by Rick Rothstein, 05-30-2014 12:13 AM
    • Replies: 2
    • Views: 61,484
    DocAElstein
    02-04-2018, 01:48 AM Go to last post

  12. 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,427
    jcoeng
    06-21-2017, 01:59 PM Go to last post

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

    Started by Rick Rothstein, 05-01-2013 07:23 PM
    1 Attachment(s)
    • Replies: 4
    • Views: 7,955
    Elijah Tice
    06-02-2017, 06:15 PM Go to last post

  14. Get Field from Delimited Text String

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

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

  16. Highlight Words In One Column That Do Not Appear In A Second Column

    Started by Rick Rothstein, 08-24-2015 10:46 PM
    • Replies: 1
    • Views: 4,504
    jomili
    01-28-2016, 07:37 PM Go to last post

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

  18. Align Data In Groups Of Columns

    Started by Rick Rothstein, 05-25-2015 03:07 AM
    • Replies: 0
    • Views: 4,599
    Rick Rothstein
    05-25-2015, 03:07 AM Go to last post

  19. Recommendation: Do not use the undocumented DATEDIF function

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

  20. 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,408
    Excel Fox
    03-28-2015, 05:52 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