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

Forum: Excel Tips and Tricks

Tips on Formula and VBA

  1. Sticky Thread Sticky: BBCode Table

    Started by pike, 01-19-2016 02:49 PM
    7 Pages
    1 2 3 ... 7
    • Replies: 61
    • Views: 27,052
    05-16-2016, 02:34 PM Go to last post
  2. Sticky Thread Sticky: Excel Macro Functions (GET.DOCUMENT)

    Started by Admin, 05-17-2011 09:33 AM
    get.document
    • Replies: 2
    • Views: 9,451
    06-29-2011, 08:40 PM Go to last post
  3. Sticky Thread Sticky: Excel Macro Functions (GET.CELL)

    Started by Admin, 05-17-2011 09:26 AM
    excel 4.0 macro xlm, excel 4.0 xlm function, get.cell
    • Replies: 0
    • Views: 7,014
    05-17-2011, 09:26 AM Go to last post
  1. Compact and Repair MS Access Database

    Started by LalitPandey87, 11-07-2011 03:44 PM
    • Replies: 8
    • Views: 4,296
    04-17-2017, 04:11 PM Go to last post
  2. Lightbulb Unpivot Columns in Excel

    Started by Admin, 12-07-2016 09:52 AM
    columns to rows, excel, unpivot, vba
    • Replies: 0
    • Views: 1,063
    12-07-2016, 09:52 AM Go to last post
  3. Lightbulb Remove a particular legend from a Chart using VBA

    Started by Admin, 01-14-2016 03:48 PM
    chart, chart object, excel, legend, series, vba
    • Replies: 0
    • Views: 686
    01-14-2016, 03:48 PM Go to last post
  4. A Blinking Christmas Tree

    Started by Rick Rothstein, 12-03-2015 04:07 AM
    • Replies: 0
    • Views: 627
    12-03-2015, 04:07 AM Go to last post
  5. Excel Dynamic Waterfall Chart

    Started by Excel Fox, 02-26-2012 02:58 PM
    • Replies: 2
    • Views: 3,707
    10-08-2015, 06:03 PM Go to last post
    • Replies: 9
    • Views: 1,134
    09-04-2015, 08:05 PM Go to last post
  6. Lightbulb Trim all Cells in a Worksheet - VBA

    Started by Admin, 09-14-2011 10:23 PM
    clean, remove spaces, trim, trim all
    • Replies: 6
    • Views: 16,604
    08-21-2015, 08:52 AM Go to last post
    • Replies: 4
    • Views: 11,115
    02-24-2015, 08:23 PM Go to last post
    • Replies: 0
    • Views: 4,328
    01-12-2015, 01:39 PM Go to last post
    • Replies: 1
    • Views: 933
    06-24-2014, 09:33 AM Go to last post
    • Replies: 1
    • Views: 772
    04-06-2014, 09:03 AM Go to last post
    • Replies: 1
    • Views: 2,477
    04-02-2014, 10:40 PM Go to last post
  7. Lightbulb Status Bar Progress Meter

    Started by Admin, 03-18-2014 03:24 PM
    progress meter, statusbar, vba
    • Replies: 2
    • Views: 1,209
    03-20-2014, 03:06 PM Go to last post
  8. Lightbulb Copy/Paste Excel Range/Chart into Powerpoint VBA

    Started by Admin, 08-29-2012 03:00 PM
    chart, copy/paste, export, powerpoint, range, vba
    • Replies: 1
    • Views: 12,250
    03-13-2014, 03:29 PM Go to last post
  9. Lightbulb Delete worksheets without loop

    Started by Admin, 08-14-2012 09:33 PM
    delete sheet, loop, vba, without loop, worksheet
    • Replies: 5
    • Views: 2,376
    03-04-2014, 07:59 PM Go to last post
  10. Lightbulb Extract Selected Data from Excel - Advanced Filter

    Started by Admin, 06-21-2013 11:50 PM
    advanced filter, extract, microsoft query, unique
    • Replies: 2
    • Views: 1,262
    01-10-2014, 11:19 AM Go to last post
  11. Finding Selected Criteria in AutoFilter

    Started by littleiitin, 01-08-2014 11:24 AM
    auto filter, criteria, selected
    • Replies: 0
    • Views: 795
    01-08-2014, 11:24 AM Go to last post
    • Replies: 6
    • Views: 1,422
    10-18-2013, 04:49 PM Go to last post
    • Replies: 0
    • Views: 1,165
    10-05-2013, 06:22 PM Go to last post
  12. Extract Number From Alphanumeric Text

    Started by Excel Fox, 10-16-2011 11:45 PM
    2 Pages
    1 2
    extract number from text, numeric from alphanumeric
    • Replies: 10
    • Views: 14,946
    09-11-2013, 10:44 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
  •