Page 2 of 6 FirstFirst 1234 ... LastLast
Threads 21 to 40 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,408
    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,330
    Admin
    05-17-2011, 08:56 AM Go to last post

  1. 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: 33,354
    Admin
    08-21-2015, 08:22 AM Go to last post

  2. Lightbulb Export data from Excel to Access Table (ADO) using VBA

    Started by Admin, 10-14-2011 08:25 AM
    ado, excel range to access, export range to access, range into access
    • Replies: 4
    • Views: 19,759
    Daydreamer
    02-24-2015, 07:53 PM Go to last post

  3. Date Format Issue When Regional Language Setting Changes And You've Used TEXT Formula

    Started by Excel Fox, 01-12-2015 01:09 PM
    2 Attachment(s)
    • Replies: 0
    • Views: 6,141
    Excel Fox
    01-12-2015, 01:09 PM Go to last post

  4. Function Code for getting Column Letter from Column Number

    Started by DocAElstein, 08-23-2014 02:27 AM
    • Replies: 0
    • Views: 14,166
    DocAElstein
    08-23-2014, 02:27 AM Go to last post

  5. Create Or Update A Hyperlink Index Of Visible Sheets

    Started by MrBlackd, 06-23-2014 04:13 AM
    • Replies: 1
    • Views: 2,594
    Admin
    06-24-2014, 09:03 AM Go to last post

  6. Lightbulb Search Directories to List Files VBA

    Started by Admin, 06-08-2011 12:26 AM
    loop through a folder, search files, sub folder
    • Replies: 3
    • Views: 11,087
    Jimmyc
    04-15-2014, 08:22 PM Go to last post

  7. Backup all modules, class modules and userforms to a selectable folder

    Started by MrBlackd, 04-06-2014 02:25 AM
    • Replies: 1
    • Views: 3,751
    Admin
    04-06-2014, 08:33 AM Go to last post

  8. Lightbulb Status Bar Progress Meter

    Started by Admin, 03-18-2014 02:54 PM
    progress meter, statusbar, vba
    • Replies: 2
    • Views: 3,544
    snb
    03-20-2014, 02:36 PM Go to last post

  9. 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: 18,825
    LalitPandey87
    03-13-2014, 02:59 PM Go to last post

  10. Lightbulb Delete worksheets without loop

    Started by Admin, 08-14-2012 09:03 PM
    delete sheet, loop, vba, without loop, worksheet
    • Replies: 5
    • Views: 5,731
    snb
    03-04-2014, 07:29 PM Go to last post

  11. Lightbulb Extract Selected Data from Excel - Advanced Filter

    Started by Admin, 06-21-2013 11:20 PM
    advanced filter, extract, microsoft query, unique
    • Replies: 2
    • Views: 3,574
    littleiitin
    01-10-2014, 10:49 AM Go to last post

  12. Finding Selected Criteria in AutoFilter

    Started by littleiitin, 01-08-2014 10:54 AM
    auto filter, criteria, selected
    • Replies: 0
    • Views: 2,206
    littleiitin
    01-08-2014, 10:54 AM Go to last post

  13. Highlighting All the Cells of Active sheet which contains a particular String:

    Started by littleiitin, 11-26-2011 08:04 PM
    cells, find a string, highlight, whole sheet
    • Replies: 6
    • Views: 4,170
    littleiitin
    10-18-2013, 04:19 PM Go to last post

  14. Dynamic Chart That Expands As More Data Is Added

    Started by Excel Fox, 10-05-2013 05:52 PM
    dynamic excel chart 2 Attachment(s)
    • Replies: 0
    • Views: 2,587
    Excel Fox
    10-05-2013, 05:52 PM Go to last post

  15. 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: 23,854
    Howardc
    09-11-2013, 10:14 PM Go to last post

  16. Lightbulb Highlight Current Row in Excel (VBA)

    Started by Admin, 10-16-2011 03:28 AM
    2 Pages •
    1 2
    highlight activecell row, highlight column, highlight current row, highlight row
    • Replies: 16
    • Views: 19,081
    Transformer
    07-31-2013, 06:46 AM Go to last post

  17. Office Version Independent Non-Activex Date Time Picker Using Form Controls

    Started by Excel Fox, 07-17-2013 12:27 AM
    1 Attachment(s)
    • Replies: 0
    • Views: 5,332
    Excel Fox
    07-17-2013, 12:27 AM Go to last post

  18. Smile Filter Pivot Table Based On Selected Value And Show All Results Though VBA

    Started by hanishgautam, 07-08-2013 07:32 PM
    1 Attachment(s)
    • Replies: 4
    • Views: 3,187
    Excel Fox
    07-09-2013, 07:47 PM Go to last post

  19. Smile Reverse a string by using array method

    Started by hanishgautam, 07-08-2013 09:17 PM
    • Replies: 2
    • Views: 2,885
    hanishgautam
    07-09-2013, 09:07 AM Go to last post

  20. Change Pivot Table Data Source Using A Drop Down List

    Started by hanishgautam, 07-05-2013 09:33 AM
    • Replies: 0
    • Views: 3,773
    hanishgautam
    07-05-2013, 09:33 AM Go to last post
Page 2 of 6 FirstFirst 1234 ... 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