low-decarie

theme_minimal <- function (base_size = 12, base_family = "") 
{
   structure(list(axis.line = theme_blank(), axis.text.x = theme_text(family = base_family, 
       size = base_size * 0.8, lineheight = 0.9, vjust = 1), 
       axis.text.y = theme_text(family = base_family, size = base_size * 
           0.8, lineheight = 0.9, hjust = 1), axis.ticks = theme_segment(colour = "black", 
           size = 0.2), axis.title.x = theme_text(family = base_family, 
           size = base_size, vjust = 0), axis.title.y = theme_text(family = base_family, 
           size = base_size, angle = 90, vjust = 0.5), axis.ticks.length = unit(0.3, 
           "lines"), axis.ticks.margin = unit(0.5, "lines"), legend.background = theme_rect(colour = NA), 

ExcelRobot

/*
Name: Unpivot Table (UNPIVOT)
Description: Given a table range with headers and array of header names, unpivots the 
   specified columns in place, optionally removing any blank entries.
Written By: Excel Robot (@ExcelRobot)
Category: Array
*/
UNPIVOT=LAMBDA(table,[columns_to_unpivot],[attribute_name],[value_name],[remove_blanks], LET(
   _ColumnsToUnpivot, IF(
      ISOMITTED(columns_to_unpivot),

guwidoe

'Attribute VB_Name = "GetLocalOneDrivePath"
'
' Cross-platform VBA Function to get the local path of OneDrive/SharePoint
' synchronized Microsoft Office files (Works on Windows and on macOS)
'
' Author: Guido Witt-Dörring
' Created: 2022/07/01
' Updated: 2024/10/01
' License: MIT
'

CHatmaker

/*  Module Contains 5g Compliant functions that deal with dates */

/*  FUNCTION NAME:  Aboutλ
    DESCRIPTION:*//**Displays the URL to this module's Gist which includes documentation*/
/*  REVISIONS:      Date        Developer       Description  
                    Mar 17 2023 Craig Hatmaker  Original Development
                    Mar 22 2023 Craig Hatmaker  Added About
                    Apr 06 2023 Craig Hatmaker  Added Help to LAMBDAs
                    Aug 28 2023 Craig Hatmaker  Conformed to new template
                    Jan 02 2024 Craig Hatmaker  See CountDOWλ

CHatmaker

/*  FUNCTION NAME:  Aboutλ
    DESCRIPTION:*//**Displays the URL to this module's Gist which includes documentation*/
/*  REVISIONS:      Date        Developer       Description  
                    Mar 02 2023 Craig Hatmaker  Original Development
                    Jun 08 2023 Craig Hatmaker  CBSE Compliant
                    Jan 17 2024 Craig Hatmaker  See DynamicArrayλ
*/

Aboutλ =TEXTSPLIT(
    "About:                         →BXL's Dynamic Array module. Suggested module name: BDR¶" &

guwidoe

Exhaustive lists of VBA Keywords and Symbols

Copyright (c) 2023 Guido Witt-Dörring (MIT License)

This document attempts to provide various exhaustive lists of VBA keywords and symbols using various categorizations. This is useful because the official documentation is convoluted and incomplete and it is very difficult to derive such lists from official sources.

If you find missing keywords or mistakes in any of the lists or have any suggestions, please don't hesitate to leave a comment below.

Table of Contents

1. Keywords

CHatmaker

/*  FUNCTION NAME:  Aboutλ
    DESCRIPTION:*//**Displays the URL to this module's Gist which includes documentation*/
/*  REVISIONS:      Date            Developer       Description  
                    Dec 14 2023     Craig Hatmaker  Original Development
*/

Aboutλ = TRIM(TEXTSPLIT(
    "About:                         →BXL's Workbook Information module. Suggested module name: BXW¶" &
    "Version:                       →Jun 12 2023¶" &
    "Gist URL:                      →https://gist.github.com/CHatmaker/3ff1b5ce97344c2dfc3f1623a656676a ¶" &

CHatmaker

/*  FUNCTION NAME:  Aboutλ
    DESCRIPTION:*//**Displays the URL to this module's Gist which includes documentation*/
/*  REVISIONS:      Date        Developer       Description  
                    Feb 27 2024 Craig Hatmaker  Copyright
                    Jun 05 2024 Craig Hatmaker  Code Simplification
                    Sep 05 2024 Craig Hatmaker  Added RunTotColsλ and RunTotRowsλ
*/

Aboutλ = TRIM(TEXTSPLIT(
    "About:                     →Basic functions for working with dynamic arrays. Suggested module name: BXE¶" &

dmonder

/*  FUNCTION NAME:  Aboutλ
    DESCRIPTION:*//**Displays the URL to this module's Gist which includes documentation*/
/*  REVISIONS:      Date            Developer       Description  
                    Mar 17 2023 Craig Hatmaker  Copyright
                    Apr 17 2023 Craig Hatmaker  Reorganizing and adding help
                    Jul 03 2023 Craig Hatmaker  See nFoldCartProdλ and PriorDimProdλ
                    Jul 11 2023 Craig Hatmaker  See UnPivotDetailλ
                    Feb 11 2024 Craig Hatmaker  See UnPivotDetailλ
*/