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,504
    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,421
    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,607
    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,278
    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,166
    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,573
    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,069
    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,530
    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,550
    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,684
    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,446
    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
    • Replies: 4
    • Views: 5,545
    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,836
    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,274
    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,793
    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,907
    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,352
    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,444
    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,403
    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
    • Replies: 2
    • Views: 7,701
    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,074
    11-16-2011, 04:32 PM Go to last post
    • Replies: 0
    • Views: 2,871
    10-31-2011, 02:31 PM Go to last post

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
  •