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: 28,680
    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: 26,502
    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,474
    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,252
    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,090
    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,440
    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: 3,990
    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,454
    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,404
    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,617
    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,373
    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,375
    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: 16,664
    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,235
    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,622
    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,806
    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,297
    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,257
    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,351
    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,602
    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: 3,968
    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,807
    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