Page 5 of 6 FirstFirst ... 3456 LastLast
Threads 81 to 100 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,340
    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,251
    Admin
    05-17-2011, 08:56 AM Go to last post

  1. Lightbulb Sort Worksheet by Color VBA

    Started by Admin, 10-25-2011 02:25 AM
    sheet sort, sort by color, sort by colour, sort sheets by color, sort worksheets
    • Replies: 0
    • Views: 3,838
    Admin
    10-25-2011, 02:25 AM Go to last post

  2. On Error Statement (Visual Basic)

    Started by Excel Fox, 10-12-2011 09:06 AM
    on error statement
    • Replies: 0
    • Views: 2,926
    Excel Fox
    10-12-2011, 09:06 AM Go to last post

  3. Unique Large Values From Duplicate List

    Started by S M C, 10-04-2011 02:17 AM
    uniqe large list, unique duplicate list
    • Replies: 0
    • Views: 2,292
    S M C
    10-04-2011, 02:17 AM Go to last post

  4. Lightbulb Execute SQL From Excel (VBA)

    Started by Mechanic, 05-13-2011 10:27 AM
    access, data, sql, sql from excel, sql in excel
    • Replies: 8
    • Views: 14,607
    Excel Fox
    10-02-2011, 04:30 PM Go to last post

  5. Lightbulb List Unique/Common Values From Two Ranges

    Started by Admin, 09-16-2011 08:34 AM
    common values, unique, unique value, unique values
    • Replies: 0
    • Views: 4,092
    Admin
    09-16-2011, 08:34 AM Go to last post

  6. Learn Excel and VBA - Useful Links

    Started by Excel Fox, 09-12-2011 12:57 AM
    learn excel
    • Replies: 0
    • Views: 3,976
    Excel Fox
    09-12-2011, 12:57 AM Go to last post

  7. Lightbulb VBA to Return the UNC(Universal Naming Convention) Path of a Mapped Network Drive

    Started by Admin, 09-06-2011 01:31 AM
    mapped drive, network path, unc
    • Replies: 0
    • Views: 21,215
    Admin
    09-06-2011, 01:31 AM Go to last post

  8. VBA Code to Clear the Immediate Window.

    Started by technicalupload, 09-02-2011 03:04 PM
    • Replies: 0
    • Views: 14,276
    technicalupload
    09-02-2011, 03:04 PM Go to last post

  9. Lightbulb Rename Filename Through VBA

    Started by Excel Fox, 08-30-2011 08:29 PM
    rename filename in vba
    • Replies: 0
    • Views: 2,580
    Excel Fox
    08-30-2011, 08:29 PM Go to last post

  10. Class Objects Created Using the CreateObject Method That Employs Late Binding

    Started by Excel Fox, 08-16-2011 12:38 PM
    createobject list, late binding objects
    • Replies: 0
    • Views: 3,788
    Excel Fox
    08-16-2011, 12:38 PM Go to last post

  11. Lightbulb Unique Count on a Filtered Range

    Started by Admin, 08-14-2011 04:29 AM
    filtered range, unique count, unique value
    • Replies: 0
    • Views: 4,308
    Admin
    08-14-2011, 04:29 AM Go to last post

  12. Lightbulb Delete Names In A Specific Worksheet

    Started by Admin, 08-14-2011 02:38 AM
    defined name, delete name
    • Replies: 0
    • Views: 2,078
    Admin
    08-14-2011, 02:38 AM Go to last post

  13. Lightbulb Change Case of Text in Excel

    Started by Admin, 08-11-2011 08:33 AM
    change case, lower, proper, sentence case, upper
    • Replies: 0
    • Views: 2,644
    Admin
    08-11-2011, 08:33 AM Go to last post

  14. Add Shape With Hyperlink To Another Sheet

    Started by Excel Fox, 07-30-2011 04:51 AM
    add shape hyperlink
    • Replies: 0
    • Views: 4,475
    Excel Fox
    07-30-2011, 04:51 AM Go to last post

  15. Pass Values Between Multiple Userforms

    Started by Excel Fox, 07-24-2011 03:25 AM
    1 Attachment(s)
    • Replies: 0
    • Views: 3,005
    Excel Fox
    07-24-2011, 03:25 AM Go to last post

  16. Lightbulb Replace Currency Format From One to Another at One go !! (VBA)

    Started by Admin, 07-19-2011 09:13 PM
    format currency
    • Replies: 0
    • Views: 3,213
    Admin
    07-19-2011, 09:13 PM Go to last post

  17. Count Alpha In AlphaNumeric Text

    Started by S M C, 07-16-2011 08:21 AM
    count alpha alphanumeric
    • Replies: 1
    • Views: 2,740
    Admin
    07-19-2011, 02:32 AM Go to last post

  18. Last Filled Cell Having Text

    Started by Excel Fox, 06-28-2011 04:25 PM
    last non-numeric value, last text entry in column 2 Attachment(s)
    • Replies: 5
    • Views: 3,741
    excelgeek
    07-18-2011, 02:33 PM Go to last post

  19. Lightbulb Lookup Multi-Column For Unique String Combination For Numeric Value Output

    Started by Excel Fox, 07-03-2011 07:23 PM
    lookup multi-column, lookup unique combination 1 Attachment(s)
    • Replies: 0
    • Views: 2,464
    Excel Fox
    07-03-2011, 07:23 PM Go to last post

  20. Lightbulb Formula To Identify A Cell Has Duplicate Words

    Started by Admin, 07-03-2011 05:52 AM
    duplicates within a cell, identify duplicates, within a cell
    • Replies: 0
    • Views: 3,602
    Admin
    07-03-2011, 05:52 AM Go to last post
Page 5 of 6 FirstFirst ... 3456 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