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.DOCUMENT)

    Started by Admin, 05-17-2011 09:03 AM
    get.document
    • Replies: 2
    • Views: 21,250
    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,875
    Admin
    05-17-2011, 08:56 AM Go to last post

  1. BBCode Table

    Started by pike, 01-19-2016 02:19 PM
    7 Pages •
    1 2 3 ... 7
    • Replies: 61
    • Views: 168,081
    DocAElstein
    05-16-2016, 02:04 PM Go to last post

  2. "What’s in a String"- VBA break down Loop through character contents of a string

    Started by DocAElstein, 02-07-2019 11:01 PM
    3 Pages •
    1 2 3
    9 Attachment(s)
    • Replies: 26
    • Views: 169,624
    DocAElstein
    07-09-2023, 04:57 PM Go to last post

  3. VBA Range.Sort with arrays. Alternative for simple use.

    Started by DocAElstein, 02-20-2019 12:59 AM
    3 Pages •
    1 2 3
    3 Attachment(s)
    • Replies: 23
    • Views: 316,623
    DocAElstein
    04-22-2019, 12:31 PM Go to last post

  4. Lightbulb Validating PAN (Indian Format)

    Started by Admin, 05-14-2012 04:01 PM
    3 Pages •
    1 2 3
    excel, formula, india, pan, validation
    • Replies: 20
    • Views: 49,454
    RoelandVerhoeven
    03-22-2023, 06:14 PM Go to last post

  5. Class Stuff: VBA Custom Classes & Objects, Class Modules

    Started by DocAElstein, 12-26-2018 04:27 PM
    2 Pages •
    1 2
    12 Attachment(s)
    • Replies: 17
    • Views: 67,189
    DocAElstein
    12-26-2018, 04:35 PM Go to last post

  6. 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,335
    Transformer
    07-31-2013, 06:46 AM Go to last post

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

  8. Excel to Excel Data transfer without opening any of the files(source or target)

    Started by Transformer, 03-23-2012 10:28 PM
    2 Pages •
    1 2
    ado, connection, excel to excel, export, import, odbc, query, transfer data
    • Replies: 14
    • Views: 9,324
    sbglobal2012
    08-22-2012, 10:57 AM Go to last post

  9. Minimize/Maximize Ribbon using VBA

    Started by LalitPandey87, 10-07-2011 07:47 AM
    2 Pages •
    1 2
    commandbars, hide, maxinize, minimize, ribbon, sendkeys, toolbar, unhide, vba
    • Replies: 10
    • Views: 24,160
    snb
    06-10-2013, 09:26 PM Go to last post

  10. Extract Number From Alphanumeric Text

    Started by Excel Fox, 10-16-2011 11:15 PM
    2 Pages •
    1 2
    extract number from text, numeric from alphanumeric
    • Replies: 10
    • Views: 19,656
    Howardc
    09-11-2013, 10:14 PM Go to last post

  11. UDF that can change values in cells other than the cell in which the UDF is used

    Started by DocAElstein, 12-26-2018 04:37 PM
    2 Pages •
    1 2
    2 Attachment(s)
    • Replies: 10
    • Views: 260,872
    DocAElstein
    10-22-2022, 01:47 PM Go to last post

  12. Summary Of Maximum Rows Used Across Each Sheet In A Workbook

    Started by Excel Fox, 09-03-2015 01:09 PM
    • Replies: 9
    • Views: 5,650
    Rick Rothstein
    09-04-2015, 07:35 PM Go to last post

  13. Lightbulb Execute SQL From Excel (VBA)

    Started by Mechanic, 05-13-2011 10:27 AM
    access, data, sql, sql from excel, sql in excel
    • Replies: 8
    • Views: 13,706
    Excel Fox
    10-02-2011, 04:30 PM Go to last post

  14. WithEvents of Excel.Application Events

    Started by DocAElstein, 12-26-2018 04:27 PM
    3 Attachment(s)
    • Replies: 8
    • Views: 59,583
    DocAElstein
    12-26-2018, 04:35 PM Go to last post

  15. ExtendingInsensibility into Code modules. Copy table contents to VBIDE VB Editor code modules. ..

    Started by DocAElstein, 12-26-2018 04:37 PM
    • Replies: 8
    • Views: 267,467
    DocAElstein
    12-26-2018, 04:43 PM Go to last post

  16. Recursion Procedures in Excel VBA. Recursion technique in coding

    Started by DocAElstein, 03-06-2019 02:02 AM
    5 Attachment(s)
    • Replies: 8
    • Views: 163,705
    DocAElstein
    03-09-2019, 10:29 PM Go to last post

  17. Item way of thinking as alternative to conventional row column looping.

    Started by DocAElstein, 03-01-2022 12:10 AM
    • Replies: 7
    • Views: 42,457
    DocAElstein
    09-05-2023, 02:20 PM Go to last post

  18. Lightbulb List all Worksheet Names Using Formula

    Started by Admin, 08-14-2011 03:41 AM
    list sheet names, worksheet names 2 Attachment(s)
    • Replies: 6
    • Views: 79,120
    KingTamo
    12-17-2012, 02:47 AM Go to last post

  19. 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: 31,194
    Admin
    08-21-2015, 08:22 AM Go to last post

  20. Highlighting All the Cells of Active sheet which contains a particular String:

    Started by littleiitin, 11-26-2011 08:04 PM
    cells, find a string, highlight, whole sheet
    • Replies: 6
    • Views: 3,560
    littleiitin
    10-18-2013, 04:19 PM Go to last post
Page 1 of 6 123 ... 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