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,144
    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. Remove Zero / Zeroes From Alphanumeric Text

    Started by Excel Fox, 04-04-2011 01:16 AM
    remove leading zero
    • Replies: 0
    • Views: 4,619
    04-04-2011, 01:16 AM Go to last post
  2. Deleting blank rows

    Started by Rasm, 04-14-2011 03:14 AM
    • Replies: 0
    • Views: 1,637
    04-14-2011, 03:14 AM Go to last post
  3. Finding Last Used Row or Column In Excel Sheet

    Started by Rasm, 04-14-2011 03:17 AM
    • Replies: 0
    • Views: 1,515
    04-14-2011, 03:17 AM Go to last post
  4. Average Of The X Largest Numbers

    Started by Excel Fox, 04-16-2011 04:15 PM
    • Replies: 0
    • Views: 1,518
    04-16-2011, 04:15 PM Go to last post
  5. Add Control to List On Right-Click

    Started by Rasm, 04-17-2011 08:16 PM
    • Replies: 0
    • Views: 2,386
    04-17-2011, 08:16 PM Go to last post
  6. Hide Ribbon and Formula Bar

    Started by Excel Fox, 04-21-2011 07:03 PM
    hide ribbon
    • Replies: 0
    • Views: 2,801
    04-21-2011, 07:03 PM Go to last post
  7. 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
    • Replies: 0
    • Views: 2,029
    04-30-2011, 11:55 PM Go to last post
  8. 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
    • Replies: 0
    • Views: 1,825
    05-09-2011, 05:19 AM Go to last post
  9. 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
  10. Number of Days In A Month

    Started by Excel Fox, 05-14-2011 08:00 PM
    number of days in month
    • Replies: 0
    • Views: 1,876
    05-14-2011, 08:00 PM Go to last post
    • Replies: 0
    • Views: 2,673
    05-15-2011, 05:49 AM Go to last post
  11. VLOOKUP with Multiple Results

    Started by Admin, 05-26-2011 10:10 PM
    • Replies: 2
    • Views: 6,433
    05-26-2011, 10:29 PM Go to last post
  12. Lightbulb Find Parent Folder From Given Folder / File Path

    Started by Excel Fox, 05-28-2011 03:17 PM
    excel formula, parent folder
    • Replies: 1
    • Views: 3,853
    05-28-2011, 03:50 PM Go to last post
  13. Lightbulb Open Folder Using VBA

    Started by Excel Fox, 06-28-2011 03:52 PM
    open folder vba
    • Replies: 0
    • Views: 3,780
    06-28-2011, 03:52 PM Go to last post
  14. 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: 1,895
    07-03-2011, 07:23 PM Go to last post
  15. Last Filled Cell Having Text

    Started by Excel Fox, 06-28-2011 04:25 PM
    • Replies: 5
    • Views: 3,055
    07-18-2011, 02:33 PM Go to last post
  16. Count Alpha In AlphaNumeric Text

    Started by S M C, 07-16-2011 08:21 AM
    count alpha alphanumeric
    • Replies: 1
    • Views: 1,912
    07-19-2011, 02:32 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
  •