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,414
    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,336
    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,842
    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,934
    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,296
    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,612
    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,096
    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,984
    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,250
    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,286
    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,584
    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,810
    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,315
    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,082
    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,649
    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,479
    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,026
    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,220
    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,748
    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,745
    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,469
    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,604
    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