Search results 64

  2. Search results
  3. conditional formatting
Sorted from new to old.
Card image
GetConfigValue

Read settings from Web.config file (or other XML files) Originally from ...

2018Aug5
Card image
CreateAnchor

Creates an anchor by passing its arguments (used to be called URL2A), can ...

2018Jul17
Card image
CreateZipFiles_7Zip

Create zip from list of files listed in List_of_Files separated by comma. The ...

2018Jul14
Card image
FindFile

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

2018Jul11
Card image
SplitTo2DArray

Splits ANStrArray into 2-Dimension array Using custom row and column ...

2018Jul9
Card image
DuplicateFileName

Generates new available file name for a certain file in order to duplicate it, ...

2018Jul7
Card image
FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

2018Jun30
Card image
Numeric-only textbox

Allow only Currency into textbox, text box will allow only nnnn.nn where n=1 ...

2018Jun27
Card image
TextPercentageMatch

Matching any part of a string in another , then returns 0 if not match, Or ...

2018Jun26
Card image
CanAccessVBA

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

2018Jun22
Card image
FGColor_Calc

To set the color of the foreground based on background color to get best look. ...

2018Jun20
Card image
BinaryFile_Read + BinaryFile_Save

Reads binary file in chunks, if not chuck defined, all file will be red/saved ...

2018Jun18
Card image
Number_Formatted

Format the number as ' <1000 = 1,2,55, 85, 989 ' <1000000 = 1K, ...

2018May26
Card image
FileSize_Formatted

Returns file size in formated human way (mb, gb, etc..) Or, it can format any ...

2018Apr25
Card image
FileDate_Formatted

Returns a formatted version of file 'LastModified' date. Pass parameter ...

2018Apr25
Card image
ClearAllCookies

Clears all cookies created by Linkedin login, and clear sessions

2018Apr23
1234