Page 2 of 6 FirstFirst 1234 ... LastLast
Threads 21 to 40 of 117

Forum: Excel and VBA Tips and Tricks

Tips on Formula and VBA

  1. 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,928
    Admin
    05-17-2011, 08:56 AM Go to last post

  2. Sticky Thread Sticky: Excel Macro Functions (GET.DOCUMENT)

    Started by Admin, 05-17-2011 09:03 AM
    get.document
    • Replies: 2
    • Views: 21,280
    Excel Fox
    06-29-2011, 08:10 PM 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,535
    Admin
    10-25-2011, 02:25 AM Go to last post

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

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

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

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

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

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

  8. Lightbulb Range Difference VBA

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

  9. 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,817
    Admin
    04-10-2012, 11:34 AM Go to last post

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

  11. Default Cell Format Changed to Date

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

  12. Lightbulb Delete worksheets without loop

    Started by Admin, 08-14-2012 09:03 PM
    delete sheet, loop, vba, without loop, worksheet
    • Replies: 5
    • Views: 5,008
    snb
    03-04-2014, 07:29 PM Go to last post

  13. Lightbulb Copy/Paste Excel Range/Chart into Powerpoint VBA

    Started by Admin, 08-29-2012 02:30 PM
    chart, copy/paste, export, powerpoint, range, vba
    • Replies: 1
    • Views: 17,462
    LalitPandey87
    03-13-2014, 02:59 PM Go to last post

  14. Lightbulb Consolidate multiple workbooks from a folder into one master file VBA

    Started by Admin, 09-22-2012 10:26 AM
    consolidate, folder, merge, multiple workbooks, vba
    • Replies: 4
    • Views: 9,377
    Admin
    02-26-2013, 09:00 PM Go to last post

  15. Remove Unused Custom Styles VBA

    Started by Admin, 08-23-2012 02:32 PM
    custom, delete style, excel 2007, excel 2010, style, unused, vba
    • Replies: 0
    • Views: 11,051
    Admin
    08-23-2012, 02:32 PM Go to last post

  16. Lightbulb Extract Selected Data from Excel - Advanced Filter

    Started by Admin, 06-21-2013 11:20 PM
    advanced filter, extract, microsoft query, unique
    • Replies: 2
    • Views: 2,902
    littleiitin
    01-10-2014, 10:49 AM Go to last post

  17. Lightbulb List File Names Using Formula

    Started by Admin, 01-20-2013 04:04 PM
    directory, file name, formula, list filenames, xl4macro
    • Replies: 0
    • Views: 2,838
    Admin
    01-20-2013, 04:04 PM Go to last post

  18. Lightbulb Status Bar Progress Meter

    Started by Admin, 03-18-2014 02:54 PM
    progress meter, statusbar, vba
    • Replies: 2
    • Views: 3,003
    snb
    03-20-2014, 02:36 PM Go to last post

  19. Lightbulb Remove a particular legend from a Chart using VBA

    Started by Admin, 01-14-2016 03:18 PM
    chart, chart object, excel, legend, series, vba
    • Replies: 1
    • Views: 17,638
    Kindred Spirit
    12-20-2018, 06:17 PM Go to last post

  20. Lightbulb Unpivot Columns in Excel

    Started by Admin, 12-07-2016 09:22 AM
    columns to rows, excel, unpivot, vba 1 Attachment(s)
    • Replies: 4
    • Views: 7,234
    jomili
    12-15-2017, 06:32 PM Go to last post
Page 2 of 6 FirstFirst 1234 ... 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