Page 4 of 6 FirstFirst ... 23456 LastLast
Threads 61 to 80 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,682
    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,642
    Admin
    05-17-2011, 08:56 AM Go to last post

  1. 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: 6,639
    Admin
    05-17-2012, 02:48 PM Go to last post

  2. Default Cell Format Changed to Date

    Started by Admin, 05-07-2012 10:14 PM
    change, custom, date, default format
    • Replies: 0
    • Views: 2,292
    Admin
    05-07-2012, 10:14 PM Go to last post

  3. Find Quarter Month From Date In Excel

    Started by Excel Fox, 04-15-2012 07:04 PM
    2 Pages •
    1 2
    month, month name, quarter
    • Replies: 15
    • Views: 12,180
    Rick Rothstein
    04-19-2012, 02:08 PM Go to last post

  4. Lightbulb VBA Function to Search in Array

    Started by Admin, 04-10-2012 11:34 AM
    array, find, join, search, string
    • Replies: 0
    • Views: 5,827
    Admin
    04-10-2012, 11:34 AM Go to last post

  5. Lightbulb Range Difference VBA

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

  6. Lightbulb Count words having more than one character in a cell

    Started by Admin, 09-30-2011 08:48 AM
    count characters, count words, evaluate, frequency
    • Replies: 3
    • Views: 3,548
    Rick Rothstein
    03-13-2012, 08:29 PM Go to last post

  7. Lightbulb Split Range into Multiple Columns VBA

    Started by Admin, 12-22-2011 01:33 AM
    split column, split into columns, split range, split range into columns
    • Replies: 3
    • Views: 10,560
    Rick Rothstein
    03-07-2012, 10:53 PM Go to last post

  8. Lightbulb Nth Largest Unique Value in an Array (UDF)

    Started by Admin, 12-04-2011 05:48 AM
    largest, nth largest, nth largest unique, unique
    • Replies: 4
    • Views: 4,694
    Admin
    03-07-2012, 12:34 PM Go to last post

  9. 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: 12,479
    Rick Rothstein
    02-28-2012, 12:04 AM Go to last post

  10. Spell a Date out in Words

    Started by Rick Rothstein, 02-22-2012 11:13 PM
    date, excel, spell, spell date in words, words 1 Attachment(s)
    • Replies: 4
    • Views: 5,677
    Rick Rothstein
    02-25-2012, 08:49 PM Go to last post

  11. Lightbulb Find Merged Cells VBA

    Started by Admin, 02-23-2012 11:02 PM
    excel, find, function, merge, merged cells, merged range, vba
    • Replies: 4
    • Views: 17,144
    Admin
    02-25-2012, 03:07 PM Go to last post

  12. 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: 3,288
    Excel Fox
    02-22-2012, 08:35 PM Go to last post

  13. Lightbulb FindAll Function In VBA

    Started by Admin, 09-13-2011 08:15 PM
    delete rows, find, find all, hide rows
    • Replies: 4
    • Views: 9,940
    Admin
    02-19-2012, 04:11 PM Go to last post

  14. Lightbulb Delete Name Ranges by Scope VBA

    Started by Admin, 12-20-2011 03:54 AM
    delete name range, delete names by scope, name range, named range, workbook scope, worksheet scope
    • Replies: 0
    • Views: 6,923
    Admin
    12-20-2011, 03:54 AM Go to last post

  15. IIF Function in VBA

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

  16. Lightbulb Create Random Number Generator VBA

    Started by Admin, 12-01-2011 03:15 AM
    random, random generator, random number, udf, unique
    • Replies: 1
    • Views: 7,473
    Admin
    12-01-2011, 10:51 AM Go to last post

  17. Minimum Value Excluding Zero In Excel Range

    Started by S M C, 11-30-2011 03:00 PM
    minimum excluding zero
    • Replies: 3
    • Views: 3,409
    Admin
    12-01-2011, 07:55 AM Go to last post

  18. 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: 7,858
    Admin
    11-24-2011, 07:54 AM Go to last post

  19. Checking Table Exist in Access Database or Not

    Started by littleiitin, 11-16-2011 09:09 AM
    access, database table, exist table
    • Replies: 1
    • Views: 4,271
    LalitPandey87
    11-16-2011, 04:32 PM Go to last post

  20. Saving Embedded Picture From Excel Workbook Sheet To Folder Hard Drive

    Started by littleiitin, 10-31-2011 02:31 PM
    • Replies: 0
    • Views: 2,888
    littleiitin
    10-31-2011, 02:31 PM Go to last post
Page 4 of 6 FirstFirst ... 23456 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