Page 4 of 6 FirstFirst ... 23456 LastLast
Threads 61 to 80 of 117

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: 20,849
    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: 17,429
    Admin
    05-17-2011, 08:56 AM Go to last post

  1. Find Last Used Row In Column

    Started by Rasm, 04-14-2011 03:34 AM
    find last row in column
    • Replies: 2
    • Views: 3,095
    Rick Rothstein
    06-04-2012, 07:40 AM Go to last post

  2. 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: 5,668
    Admin
    05-17-2012, 02:48 PM Go to last post

  3. Default Cell Format Changed to Date

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

  4. 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: 11,247
    Rick Rothstein
    04-19-2012, 02:08 PM Go to last post

  5. Lightbulb VBA Function to Search in Array

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

  6. Lightbulb Range Difference VBA

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

  7. 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: 2,814
    Rick Rothstein
    03-13-2012, 08:29 PM Go to last post

  8. 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: 9,553
    Rick Rothstein
    03-07-2012, 10:53 PM Go to last post

  9. 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: 3,988
    Admin
    03-07-2012, 12:34 PM Go to last post

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

  11. 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: 4,475
    Rick Rothstein
    02-25-2012, 08:49 PM Go to last post

  12. 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: 15,611
    Admin
    02-25-2012, 03:07 PM Go to last post

  13. 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: 2,651
    Excel Fox
    02-22-2012, 08:35 PM Go to last post

  14. Lightbulb FindAll Function In VBA

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

  15. 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,089
    Admin
    12-20-2011, 03:54 AM Go to last post

  16. IIF Function in VBA

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

  17. 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: 6,071
    Admin
    12-01-2011, 10:51 AM Go to last post

  18. Minimum Value Excluding Zero In Excel Range

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

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

  20. 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: 2,821
    LalitPandey87
    11-16-2011, 04:32 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