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,252
    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,880
    Admin
    05-17-2011, 08:56 AM Go to last post

  1. Upload Excel Data to SQL Table

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

  2. Find Last Used Row In Column

    Started by Rasm, 04-14-2011 03:34 AM
    find last row in column
    • Replies: 2
    • Views: 3,238
    Rick Rothstein
    06-04-2012, 07:40 AM Go to last post

  3. VLOOKUP with Multiple Results

    Started by Admin, 05-26-2011 10:10 PM
    • Replies: 2
    • Views: 6,747
    Admin
    05-26-2011, 10:29 PM Go to last post

  4. Lightbulb Get Chart's Source Data VBA

    Started by Admin, 11-22-2011 05:23 PM
    application.international, chart, datalabel, evaluate, seriescollection, source data, source range, ticklabel 1 Attachment(s)
    • Replies: 2
    • Views: 6,925
    Admin
    11-24-2011, 07:54 AM Go to last post

  5. Week Of The Month

    Started by Excel Fox, 02-22-2012 06:24 PM
    month week, week in month, week number per month
    • Replies: 2
    • Views: 2,849
    Excel Fox
    02-22-2012, 08:35 PM Go to last post

  6. 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: 8,319
    Alex Nazarenko
    10-08-2015, 05:33 PM Go to last post

  7. Lightbulb Range Difference VBA

    Started by Admin, 03-21-2012 02:45 AM
    difference, range, vba
    • Replies: 2
    • Views: 3,396
    Admin
    03-21-2012, 05:58 PM Go to last post

  8. Lightbulb Number validation in Text Boxes VBA

    Started by Admin, 05-17-2012 10:57 AM
    numbers only, numerics only, text box, userform, validate
    • Replies: 2
    • Views: 5,844
    Admin
    05-17-2012, 02:48 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,587
    Rick Rothstein
    03-21-2013, 09:27 PM Go to last post

  10. 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: 2,882
    littleiitin
    01-10-2014, 10:49 AM Go to last post

  11. Smile Reverse a string by using array method

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

  12. Lightbulb Status Bar Progress Meter

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

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

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

  14. Convert Text In YYYYMMDD Format To Date Format

    Started by S M C, 05-16-2011 03:38 PM
    yyyymmdd to date
    • Replies: 1
    • Views: 11,413
    Rick Rothstein
    02-28-2012, 12:04 AM Go to last post

  15. Lightbulb Find Parent Folder From Given Folder / File Path

    Started by Excel Fox, 05-28-2011 03:17 PM
    excel formula, parent folder
    • Replies: 1
    • Views: 4,193
    Excel Fox
    05-28-2011, 03:50 PM Go to last post

  16. Date & Time Formats in Different Languages

    Started by Haseeb A, 06-06-2012 03:31 AM
    1 Attachment(s)
    • Replies: 1
    • Views: 2,496
    Mahesh
    06-10-2012, 02:57 PM Go to last post

  17. IIF Function in VBA

    Started by Nishant Choudhary, 12-01-2011 06:46 PM
    • Replies: 1
    • Views: 10,979
    Admin
    12-01-2011, 08:51 PM Go to last post

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

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

  19. Create Or Update A Hyperlink Index Of Visible Sheets

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

  20. 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,607
    Kindred Spirit
    12-20-2018, 06:17 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