Page 1 of 6 123 ... LastLast
Threads 1 to 20 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,143
    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: 20,652
    06-29-2011, 08:10 PM Go to last post
  1. Count Files In A Folder VBA

    Started by Admin, 05-07-2011 10:57 PM
    count files in a folder
    • Replies: 0
    • Views: 6,272
    05-07-2011, 10:57 PM Go to last post
  2. COUNTIF on Non-contiguous Range

    Started by Admin, 04-23-2011 04:05 PM
    • Replies: 0
    • Views: 2,436
    04-23-2011, 04:05 PM Go to last post
  3. Lightbulb Save Chart As A Picture VBA

    Started by Admin, 05-14-2011 04:28 PM
    bmp, gif, jpg, save chart as picture
    • Replies: 0
    • Views: 3,945
    05-14-2011, 04:28 PM Go to last post
  4. VLOOKUP with Multiple Results

    Started by Admin, 05-26-2011 10:10 PM
    • Replies: 2
    • Views: 6,432
    05-26-2011, 10:29 PM Go to last post
  5. Lightbulb Search Directories to List Files VBA

    Started by Admin, 06-08-2011 12:26 AM
    loop through a folder, search files, sub folder
    • Replies: 3
    • Views: 10,059
    04-15-2014, 08:22 PM Go to last post
  6. Lightbulb Formula To Identify A Cell Has Duplicate Words

    Started by Admin, 07-03-2011 05:52 AM
    duplicates within a cell, identify duplicates, within a cell
    • Replies: 0
    • Views: 2,884
    07-03-2011, 05:52 AM Go to last post
    • Replies: 0
    • Views: 2,638
    07-19-2011, 09:13 PM Go to last post
  7. Lightbulb Change Case of Text in Excel

    Started by Admin, 08-11-2011 08:33 AM
    change case, lower, proper, sentence case, upper
    • Replies: 0
    • Views: 2,187
    08-11-2011, 08:33 AM Go to last post
  8. Lightbulb Delete Names In A Specific Worksheet

    Started by Admin, 08-14-2011 02:38 AM
    defined name, delete name
    • Replies: 0
    • Views: 1,513
    08-14-2011, 02:38 AM Go to last post
  9. Lightbulb List all Worksheet Names Using Formula

    Started by Admin, 08-14-2011 03:41 AM
    • Replies: 6
    • Views: 78,779
    12-17-2012, 02:47 AM Go to last post
  10. Lightbulb Unique Count on a Filtered Range

    Started by Admin, 08-14-2011 04:29 AM
    filtered range, unique count, unique value
    • Replies: 0
    • Views: 1,784
    08-14-2011, 04:29 AM Go to last post
  11. Lightbulb Lock Cells After Data Entered

    Started by Admin, 09-05-2011 05:19 AM
    enter data, lock cells
    • Replies: 4
    • Views: 8,666
    06-28-2013, 10:52 PM Go to last post
    • Replies: 0
    • Views: 19,727
    09-06-2011, 01:31 AM Go to last post
  12. 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,783
    02-19-2012, 04:11 PM Go to last post
  13. Lightbulb List Unique/Common Values From Two Ranges

    Started by Admin, 09-16-2011 08:34 AM
    common values, unique, unique value, unique values
    • Replies: 0
    • Views: 3,511
    09-16-2011, 08:34 AM Go to last post
  14. Lightbulb Trim all Cells in a Worksheet - VBA

    Started by Admin, 09-14-2011 09:53 PM
    clean, remove spaces, trim, trim all
    • Replies: 6
    • Views: 30,453
    08-21-2015, 08:22 AM Go to last post
  15. 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,810
    03-13-2012, 08:29 PM Go to last post
    • Replies: 1
    • Views: 7,145
    04-25-2013, 07:51 PM Go to last post
    • Replies: 4
    • Views: 17,372
    02-24-2015, 07:53 PM Go to last post
  16. Lightbulb Highlight Current Row in Excel (VBA)

    Started by Admin, 10-16-2011 03:28 AM
    2 Pages
    1 2
    highlight activecell row, highlight column, highlight current row, highlight row
    • Replies: 16
    • Views: 17,018
    07-31-2013, 06:46 AM 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
  •