Page 3 of 6 FirstFirst 12345 ... LastLast
Threads 41 to 60 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: 21,092
    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: 17,679
    Admin
    05-17-2011, 08:56 AM Go to last post

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

    Started by hanishgautam, 07-05-2013 09:33 AM
    • Replies: 0
    • Views: 3,042
    hanishgautam
    07-05-2013, 09:33 AM Go to last post

  2. Lightbulb Lock Cells After Data Entered

    Started by Admin, 09-05-2011 05:19 AM
    enter data, lock cells
    • Replies: 4
    • Views: 8,825
    Admin
    06-28-2013, 10:52 PM Go to last post

  3. Freeze Time Using Excel Formula To Freeze Date

    Started by Excel Fox, 03-29-2013 01:50 AM
    cach hoc tieng anh, hoc tot tieng anh, trung tam tieng anh
    • Replies: 1
    • Views: 14,224
    Excel Fox
    06-28-2013, 08:11 PM Go to last post

  4. 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: 24,029
    snb
    06-10-2013, 09:26 PM Go to last post

  5. Remove Special Characters From Text Or Remove Numbers From Text

    Started by Excel Fox, 05-30-2013 10:51 AM
    • Replies: 5
    • Views: 3,950
    snb
    05-31-2013, 04:43 PM Go to last post

  6. Replace Pivot Table Source Range with New Address VBA

    Started by Admin, 05-05-2012 01:11 AM
    address, pivot, pivot cache, pivot table, source range, vba
    • Replies: 1
    • Views: 7,225
    rafal1122
    04-25-2013, 07:51 PM Go to last post

  7. Retain Conditional Format Color When Copying A Range To Another Sheet Or Workbook

    Started by Excel Fox, 04-10-2013 12:33 PM
    • Replies: 0
    • Views: 5,593
    Excel Fox
    04-10-2013, 12:33 PM Go to last post

  8. Loop Through And Delete Multiple File Types In A Folder

    Started by Excel Fox, 03-30-2013 04:47 PM
    • Replies: 0
    • Views: 1,596
    Excel Fox
    03-30-2013, 04:47 PM Go to last post

  9. Replace Incorrect Date In Cell To Another Valid Date

    Started by DARSHANKmandya, 03-21-2013 08:45 PM
    • Replies: 2
    • Views: 2,446
    Rick Rothstein
    03-21-2013, 09:27 PM Go to last post

  10. Lightbulb Consolidate multiple workbooks from a folder into one master file VBA

    Started by Admin, 09-22-2012 10:26 AM
    consolidate, folder, merge, multiple workbooks, vba
    • Replies: 4
    • Views: 9,227
    Admin
    02-26-2013, 09:00 PM Go to last post

  11. Lightbulb List File Names Using Formula

    Started by Admin, 01-20-2013 04:04 PM
    directory, file name, formula, list filenames, xl4macro
    • Replies: 0
    • Views: 2,657
    Admin
    01-20-2013, 04:04 PM Go to last post

  12. VLookup Any Matching Word From A Sentence

    Started by Excel Fox, 12-30-2012 11:55 AM
    • Replies: 0
    • Views: 7,623
    Excel Fox
    12-30-2012, 11:55 AM Go to last post

  13. Lightbulb List all Worksheet Names Using Formula

    Started by Admin, 08-14-2011 03:41 AM
    list sheet names, worksheet names 2 Attachment(s)
    • Replies: 6
    • Views: 78,990
    KingTamo
    12-17-2012, 02:47 AM Go to last post

  14. Converting a Column Number to a Column Letter

    Started by Rasm, 04-07-2011 03:26 AM
    column number to letter
    • Replies: 6
    • Views: 3,796
    Rick Rothstein
    12-17-2012, 02:29 AM Go to last post

  15. Sort data sheet by right_click of mouse

    Started by Rasm, 10-29-2011 06:21 PM
    1 Attachment(s)
    • Replies: 3
    • Views: 2,514
    salman8200
    12-08-2012, 07:34 PM Go to last post

  16. Random Unique Number Generator Excel VBA

    Started by Excel Fox, 10-17-2012 01:22 AM
    random unique number
    • Replies: 5
    • Views: 9,462
    Rick Rothstein
    10-18-2012, 01:00 PM Go to last post

  17. Remove Unused Custom Styles VBA

    Started by Admin, 08-23-2012 02:32 PM
    custom, delete style, excel 2007, excel 2010, style, unused, vba
    • Replies: 0
    • Views: 10,911
    Admin
    08-23-2012, 02:32 PM Go to last post

  18. Upload Excel Data to SQL Table

    Started by littleiitin, 11-03-2011 12:28 PM
    • Replies: 3
    • Views: 3,242
    sbglobal2012
    08-22-2012, 11:02 AM Go to last post

  19. Excel to Excel Data transfer without opening any of the files(source or target)

    Started by Transformer, 03-23-2012 10:28 PM
    2 Pages •
    1 2
    ado, connection, excel to excel, export, import, odbc, query, transfer data
    • Replies: 14
    • Views: 9,002
    sbglobal2012
    08-22-2012, 10:57 AM Go to last post

  20. Date & Time Formats in Different Languages

    Started by Haseeb A, 06-06-2012 03:31 AM
    1 Attachment(s)
    • Replies: 1
    • Views: 2,370
    Mahesh
    06-10-2012, 02:57 PM Go to last post
Page 3 of 6 FirstFirst 12345 ... 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