Page 1 of 6 123 ... LastLast
Threads 1 to 20 of 116

Forum: Excel and VBA Tips and Tricks

Tips on Formula and VBA

  1. Sticky Thread Sticky: Excel Macro Functions (GET.DOCUMENT)

    Started by Admin, 05-17-2011 09:03 AM
    get.document
    • Replies: 2
    • Views: 29,656
    Excel Fox
    06-29-2011, 08:10 PM Go to last post

  2. Sticky Thread Sticky: Excel Macro Functions (GET.CELL)

    Started by Admin, 05-17-2011 08:56 AM
    excel 4.0 macro xlm, excel 4.0 xlm function, get.cell
    • Replies: 1
    • Views: 27,587
    Admin
    05-17-2011, 08:56 AM Go to last post

  1. Class Stuff: VBA Custom Classes & Objects, Class Modules

    Started by DocAElstein, 12-26-2018 04:27 PM
    3 Pages •
    1 2 3
    24 Attachment(s)
    • Replies: 29
    • Views: 103,837
    DocAElstein
    06-02-2024, 01:49 PM Go to last post

  2. Item way of thinking as alternative to conventional row column looping.

    Started by DocAElstein, 03-01-2022 12:10 AM
    • Replies: 7
    • Views: 162,805
    DocAElstein
    09-05-2023, 02:20 PM Go to last post

  3. "What’s in a String"- VBA break down Loop through character contents of a string

    Started by DocAElstein, 02-07-2019 11:01 PM
    3 Pages •
    1 2 3
    9 Attachment(s)
    • Replies: 26
    • Views: 190,900
    DocAElstein
    07-09-2023, 04:57 PM Go to last post

  4. Lightbulb Validating PAN (Indian Format)

    Started by Admin, 05-14-2012 04:01 PM
    3 Pages •
    1 2 3
    excel, formula, india, pan, validation
    • Replies: 20
    • Views: 103,372
    RoelandVerhoeven
    03-22-2023, 06:14 PM Go to last post

  5. UDF that can change values in cells other than the cell in which the UDF is used

    Started by DocAElstein, 12-26-2018 04:37 PM
    2 Pages •
    1 2
    2 Attachment(s)
    • Replies: 10
    • Views: 274,061
    DocAElstein
    10-22-2022, 01:47 PM Go to last post

  6. Position that light grey Boarder line anywhere in the VB Editor

    Started by DocAElstein, 02-04-2021 09:55 PM
    1 Attachment(s)
    • Replies: 0
    • Views: 24,804
    DocAElstein
    02-04-2021, 09:55 PM Go to last post

  7. VBA Range.Sort with arrays. Alternative for simple use.

    Started by DocAElstein, 02-20-2019 12:59 AM
    3 Pages •
    1 2 3
    3 Attachment(s)
    • Replies: 23
    • Views: 333,786
    DocAElstein
    04-22-2019, 12:31 PM Go to last post

  8. Recursion Procedures in Excel VBA. Recursion technique in coding

    Started by DocAElstein, 03-06-2019 02:02 AM
    5 Attachment(s)
    • Replies: 8
    • Views: 172,089
    DocAElstein
    03-09-2019, 10:29 PM Go to last post

  9. ExtendingInsensibility into Code modules. Copy table contents to VBIDE VB Editor code modules. ..

    Started by DocAElstein, 12-26-2018 04:37 PM
    • Replies: 8
    • Views: 276,422
    DocAElstein
    12-26-2018, 04:43 PM Go to last post

  10. WithEvents of Excel.Application Events

    Started by DocAElstein, 12-26-2018 04:27 PM
    3 Attachment(s)
    • Replies: 8
    • Views: 68,134
    DocAElstein
    12-26-2018, 04:35 PM Go to last post

  11. Lightbulb Remove a particular legend from a Chart using VBA

    Started by Admin, 01-14-2016 03:18 PM
    chart, chart object, excel, legend, series, vba
    • Replies: 1
    • Views: 26,467
    Kindred Spirit
    12-20-2018, 06:17 PM Go to last post

  12. Post How to Use the AutoSum Function in Microsoft Excel

    Started by Rajan Vishwakarma, 06-18-2018 03:34 PM
    autosum in excel
    • Replies: 0
    • Views: 9,738
    Rajan Vishwakarma
    06-18-2018, 03:34 PM Go to last post

  13. Upgrade to LookUpConcat UDF: Search Multiple Criteria and concatenate.

    Started by DJE, 04-02-2014 09:26 PM
    concatenate, excel, lookupconcat, search 1 Attachment(s)
    • Replies: 3
    • Views: 17,797
    station
    05-23-2018, 12:18 AM Go to last post

  14. Excel VBA comma point thousand decimal separator number problem.

    Started by DocAElstein, 02-17-2018 06:02 PM
    2 Attachment(s)
    • Replies: 2
    • Views: 344,050
    DocAElstein
    02-17-2018, 06:09 PM Go to last post

  15. Lightbulb Unpivot Columns in Excel

    Started by Admin, 12-07-2016 09:22 AM
    columns to rows, excel, unpivot, vba 1 Attachment(s)
    • Replies: 4
    • Views: 16,657
    jomili
    12-15-2017, 06:32 PM Go to last post

  16. Showing progress bar in a status bar :)

    Started by Admin, 08-12-2017 01:01 PM
    progress bar, progress meter, vba
    • Replies: 0
    • Views: 13,551
    Admin
    08-12-2017, 01:01 PM Go to last post

  17. BBCode Table

    Started by pike, 01-19-2016 02:19 PM
    7 Pages •
    1 2 3 ... 7
    • Replies: 61
    • Views: 200,185
    DocAElstein
    05-16-2016, 02:04 PM Go to last post

  18. A Blinking Christmas Tree

    Started by Rick Rothstein, 12-03-2015 03:37 AM
    • Replies: 0
    • Views: 10,037
    Rick Rothstein
    12-03-2015, 03:37 AM Go to last post

  19. Excel Dynamic Waterfall Chart

    Started by Excel Fox, 02-26-2012 02:28 PM
    excel dynamic waterfall, excel waterfall chart 3 Attachment(s)
    • Replies: 2
    • Views: 15,714
    Alex Nazarenko
    10-08-2015, 05:33 PM Go to last post

  20. Summary Of Maximum Rows Used Across Each Sheet In A Workbook

    Started by Excel Fox, 09-03-2015 01:09 PM
    • Replies: 9
    • Views: 15,398
    Rick Rothstein
    09-04-2015, 07:35 PM Go to last post
Page 1 of 6 123 ... LastLast

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