Search results 23

  2. Search results
  3. boolean
Sorted from new to old.
Card image
ANmExcelTableAddress

Returns reference of a table in Excel workbook. This is because not all tables ...

Fri 9AM
Card image
BusinessDateAdd

Counts the number of business days Add or subtract a number of business days ...

2023Oct11
Card image
BooleanCount

Counts how many values are True (or anything) in an array of boolean values ...

2022Apr22
Card image
Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

2021Dec30
Card image
Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

2021Jun23
Card image
SortedFiles

Get a sorted list of files in a directory using the File System Object (FSO) ...

2020Aug11
Card image
Is64Bit

Determine if system is 64 bit or not. Related to

2020Feb7
Card image
PrettyPath

Formats a path for use in user displays, trim it beautifully. PrettyPath is ...

2018Sep23
Card image
RunFromShared

Check is this VBA-Excel file is running from a shared folder (Starts with \\) ...

2018Aug9
Card image
FindFile

Finds if a workbook is open or not in same Excel session

2018Jul11
Card image
WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

2018Jul9
Card image
IIF

Works the same as it's VB IIF equivalent. IIf will coerce an expression into ...

2018Jul7
Card image
FindVBAObject

Finds specific VBA object in VBE project User need to setup to trust VBA ...

2018Jul6
Card image
XorC

Simple small function to Encrypt or Decrypt a string Test_XorC is for testing ...

2018Jul1
Card image
DeleteAllFiles

Delete All Files in a Folder. Needs a reference to Microsoft Scripting Runtime

2018Jun30
Card image
CanAccessVBA

Returns true if VBA is accessible through code, returns false if not

2018Jun22
12