'Statements' category


Subcategories

  • DO LOOP statement (1)
  • FOR NEXT statement (6)
  • GoTo statement (1)
  • IF THEN ELSE statement (6)
  • SELECT CASE statement (1)
  • SET statement (1)
  • WITH … END WITH Statement (4)

    • test
    How to use the DO LOOP statement
    The Do Loop statement allows you to repeat specific code until a condition is met. There are two possible ways […]
    test
    How to use the FOR NEXT statement
    Table of Contents FOR NEXT statement FOR NEXT with a counter variable FOR each NEXT example FOR NEXT with counter […]
    test
    How to use the IF THEN ELSE ELSEIF END IF statement [VBA]
    This article demonstrates how to use the If ... Then statement in Visual Basic for Applications (VBA). You can combine […]
    test
    Extract cell references from a formula
    This article demonstrates a User Defined Function that allows you to extract cell references from a formula in a given […]
    test
    Resize a range of values (UDF)
    The User Defined Function (UDF) demonstrated in this article, resizes a given range to columns or rows you specify. This […]
    test
    Find the most/least consecutive repeated value [VBA]
    This post Find the longest/smallest consecutive sequence of a value has a few really big array formulas. Today I would like to […]
    test
    Working with comments – VBA
    Did you know that you can select all cells containing comments in the current sheet? Press F5, press with left […]
    test
    How to highlight row of the selected cell programmatically
    Today I would like to share with you these small event handler procedures that make it easier for you to […]
    test
    Finding the shortest path – A * pathfinding
    What's on this page Finding the shortest path - A * pathfinding Optimize pick path in a warehouse   1. […]
    test
    Customize Excel maze
    Terry wants to make a different sized maze and I think that is a great idea. Perhaps you remember that I […]
    test
    Show / hide a picture using a button
    This article explains how to hide a specific image in Excel using a shape as a button. If the user […]
    test
    Run a Macro from a Drop Down list [VBA]
    This article demonstrates how to run a VBA macro using a Drop Down list. The Drop Down list contains two […]
    test
    Excel calendar
    Table of Contents Excel monthly calendar - VBA  Calendar Drop down lists Headers Calculating dates (formula) Conditional formatting Today Dates […]
    test
    Create links to all sheets in a workbook programmatically
    The macro demonstrated above creates hyperlinks to all worksheets in the current worksheet.  You will then be able to quickly […]

    Excel formula categories

    AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values

    Excel categories


    Home page
    Excel Functions
    Excel Formulas
    Excel Tables
    Advanced Filter
    Data Validation
    Drop Down List
    Named Ranges
    Excel Solver
    Charts
    Conditonal Formatting
    Pivot Tables
    VBA
    Macros
    UDFs
    Archive