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

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: 20,654
    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: 17,150
    05-17-2011, 08:56 AM Go to last post
    • Replies: 2
    • Views: 334,446
    02-17-2018, 06:09 PM Go to last post
  1. VBA Range.Sort with arrays. Alternative for simple use.

    Started by DocAElstein, 02-20-2019 12:59 AM
    3 Pages
    1 2 3
    • Replies: 23
    • Views: 315,652
    04-22-2019, 12:31 PM Go to last post
    • Replies: 10
    • Views: 260,299
    10-22-2022, 01:47 PM Go to last post
    • Replies: 26
    • Views: 167,358
    07-09-2023, 04:57 PM Go to last post
  2. BBCode Table

    Started by pike, 01-19-2016 02:19 PM
    7 Pages
    1 2 3 ... 7
    • Replies: 61
    • Views: 165,183
    05-16-2016, 02:04 PM Go to last post
    • Replies: 8
    • Views: 162,895
    03-09-2019, 10:29 PM Go to last post
  3. Lightbulb List all Worksheet Names Using Formula

    Started by Admin, 08-14-2011 03:41 AM
    • Replies: 6
    • Views: 78,781
    12-17-2012, 02:47 AM Go to last post
  4. Class Stuff: VBA Custom Classes & Objects, Class Modules

    Started by DocAElstein, 12-26-2018 04:27 PM
    2 Pages
    1 2
    • Replies: 17
    • Views: 66,286
    12-26-2018, 04:35 PM Go to last post
  5. WithEvents of Excel.Application Events

    Started by DocAElstein, 12-26-2018 04:27 PM
    • Replies: 8
    • Views: 58,962
    12-26-2018, 04:35 PM Go to last post
  6. 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: 47,898
    03-22-2023, 06:14 PM Go to last post
  7. Lightbulb Trim all Cells in a Worksheet - VBA

    Started by Admin, 09-14-2011 09:53 PM
    clean, remove spaces, trim, trim all
    • Replies: 6
    • Views: 30,460
    08-21-2015, 08:22 AM Go to last post
  8. Minimize/Maximize Ribbon using VBA

    Started by LalitPandey87, 10-07-2011 07:47 AM
    2 Pages
    1 2
    commandbars, hide, maxinize, minimize, ribbon, sendkeys, toolbar, unhide, vba
    • Replies: 10
    • Views: 23,848
    06-10-2013, 09:26 PM Go to last post
    • Replies: 7
    • Views: 22,692
    09-05-2023, 02:20 PM Go to last post
    • Replies: 0
    • Views: 19,729
    09-06-2011, 01:31 AM Go to last post
  9. Extract Number From Alphanumeric Text

    Started by Excel Fox, 10-16-2011 11:15 PM
    2 Pages
    1 2
    extract number from text, numeric from alphanumeric
    • Replies: 10
    • Views: 18,964
    09-11-2013, 10:14 PM Go to last post
    • Replies: 0
    • Views: 17,770
    02-04-2021, 09:55 PM Go to last post
    • Replies: 4
    • Views: 17,375
    02-24-2015, 07:53 PM Go to last post
  10. 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: 17,057
    12-20-2018, 06:17 PM Go to last post
  11. Lightbulb Copy/Paste Excel Range/Chart into Powerpoint VBA

    Started by Admin, 08-29-2012 02:30 PM
    chart, copy/paste, export, powerpoint, range, vba
    • Replies: 1
    • Views: 17,033
    03-13-2014, 02:59 PM Go to last post

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
  •