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. A Blinking Christmas Tree

    Started by Rick Rothstein, 12-16-2012 09:30 AM
    1 Attachment(s)
    • Replies: 5
    • Views: 10,534
    swinnersmusic
    12-28-2014, 02:48 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,256
    Rick Rothstein
    07-07-2021, 06:43 AM Go to last post

  3. 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: 34,945
    JohanRyman
    09-02-2014, 04:20 PM Go to last post

  4. Align Data In Groups Of Columns

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

  5. Breaking the rules for UDF's (User Defined Functions)

    Started by Rick Rothstein, 10-16-2013 02:12 AM
    • Replies: 6
    • Views: 5,593
    Rick Rothstein
    10-19-2013, 10:40 PM 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:13 AM
    int division back slash
    • Replies: 4
    • Views: 4,208
    Excel Fox
    04-22-2013, 04:52 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 09:32 PM
    base, binary, conversion, decimal, hex, vba
    • Replies: 3
    • Views: 7,357
    Rick Rothstein
    03-31-2013, 06:18 AM Go to last post

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

  9. Do you know when Easter is this year?

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

  10. Excel Number Format: Indian Style Comma Separation

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

  11. 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,545
    aimhigh85
    02-10-2013, 06:19 AM Go to last post

  12. 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,858
    Rick Rothstein
    06-21-2012, 09:42 PM Go to last post

  13. FindAll function

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

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

    Started by Rick Rothstein, 10-12-2012 01:30 AM
    • Replies: 1
    • Views: 6,135
    Rick Rothstein
    10-16-2012, 01:53 PM Go to last post

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

  16. 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: 6,974
    Rick Rothstein
    04-14-2012, 10:46 PM Go to last post

  17. FORMATTED Flexible Concatenation Function

    Started by Rick Rothstein, 09-25-2012 10:52 PM
    • Replies: 1
    • Views: 7,005
    chathuraa
    10-14-2012, 03:48 PM Go to last post

  18. Free U.S. ZIP CODE Database...

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

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

  20. Get "Reversed" Field from Delimited Text String

    Started by Rick Rothstein, 03-16-2012 08:21 AM
    • Replies: 3
    • Views: 12,021
    JeffreyWeir
    02-22-2015, 09:01 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