Threads 1 to 14 of 14

Forum: Familiar with Commands and Formulas

This is an area to describe VBA command or Formula with its syntax

  1. Right Hand Side Range Range Value values Range=Range.Value only sometimes. Range Range.Value Anomaly

    Started by DocAElstein, 08-14-2023 12:17 PM
    • Replies: 2
    • Views: 3,561
    DocAElstein
    08-14-2023, 12:17 PM Go to last post

  2. Resume On Error GoTo 0 -1 GoTo Error Handling Statements Runtime VBA Err Handling ORNeRe GoRoT N0Nula 1

    Started by DocAElstein, 03-22-2018 11:57 PM
    6 Pages •
    1 2 3 ... 6
    10 Attachment(s)
    • Replies: 51
    • Views: 92,188
    DocAElstein
    10-22-2022, 01:47 PM Go to last post

  3. VBA referring to external shared Libraries, 1) Early, 1.5) Laterly Early and 2) Late Binding Techniques

    Started by DocAElstein, 03-23-2018 12:39 AM
    10 Attachment(s)
    • Replies: 9
    • Views: 76,286
    DocAElstein
    05-13-2021, 02:31 PM Go to last post

  4. Named Ranges and Named Ranges scope. Referencing a named range

    Started by DocAElstein, 11-18-2018 04:30 PM
    2 Pages •
    1 2
    2 Attachment(s)
    • Replies: 10
    • Views: 180,369
    DocAElstein
    11-18-2018, 06:33 PM Go to last post

  5. Built in VBA methods and functions to alter the contents of existing character strings

    Started by DocAElstein, 02-14-2018 03:09 AM
    • Replies: 1
    • Views: 283,935
    DocAElstein
    02-14-2018, 03:09 AM Go to last post

  6. VBA Input Pop up Boxes: Application.InputBox Method versus VBA.InputBox Function

    Started by DocAElstein, 02-03-2018 11:17 PM
    2 Pages •
    1 2
    1 Attachment(s)
    • Replies: 12
    • Views: 293,035
    DocAElstein
    02-09-2018, 02:48 AM Go to last post

  7. VBA Range.Insert Method: Code line makes a space to put new range in

    Started by DocAElstein, 01-24-2018 08:37 PM
    • Replies: 9
    • Views: 151,212
    DocAElstein
    01-24-2018, 08:54 PM Go to last post

  8. Excel VBA Interception and Implicit Intersection and VLookUp

    Started by DocAElstein, 02-02-2017 09:17 PM
    2 Pages •
    1 2
    • Replies: 12
    • Views: 355,809
    DocAElstein
    03-15-2017, 05:00 AM Go to last post

  9. Understanding VBA Range Object Properties and referring to ranges and spreadsheet cells

    Started by DocAElstein, 01-20-2017 07:25 PM
    • Replies: 3
    • Views: 89,279
    DocAElstein
    01-25-2017, 04:55 AM Go to last post

  10. Lightbulb Difference Between 'On Error GoTo 0' And 'On Error GoTo -1'

    Started by Transformer, 04-09-2013 04:27 PM
    • Replies: 7
    • Views: 33,281
    DocAElstein
    07-02-2015, 04:07 PM Go to last post

  11. Lightbulb Application.Caller

    Started by Transformer, 05-01-2013 12:32 PM
    • Replies: 0
    • Views: 22,458
    Transformer
    05-01-2013, 12:32 PM Go to last post

  12. How To Use Frequency Function In Excel

    Started by Transformer, 04-09-2013 10:40 AM
    • Replies: 1
    • Views: 11,206
    Admin
    04-09-2013, 11:49 AM Go to last post

  13. Val Function

    Started by Transformer, 06-11-2012 10:49 AM
    2 Pages •
    1 2
    function, val, vba
    • Replies: 10
    • Views: 29,707
    mrmmickle1
    09-14-2012, 04:12 PM Go to last post

  14. Number 9.99999999E+307 in Excel Formula

    Started by Admin, 06-11-2012 04:09 PM
    • Replies: 0
    • Views: 16,622
    Admin
    06-11-2012, 04:09 PM 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
  •  

Forum Rules