Search results 184

  2. Search results
  3. end
Sorted from new to old.
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
Error_Raise

To raise a friendly error message with option to show custom error number and ...

2018Jul7
Card image
Cookies warning

Thanks to new law in Europe, we need to show users and let them accept a ...

2018Jul6
Card image
PI

Returns a double representing the mathematical constant Pi

2018Jul5
Card image
ServerVar

Get value of Server variable by passing variable name aVar can be any of these ...

2018Jul4
Card image
DegreeC2F + DegreeF2C

Convert Celsius to Fahrenheit and Fahrenheit to Celsius degrees

2018Jul3
Card image
Numeric-only textbox

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

2018Jun27
Card image
CellSave (SimpleSave)

Saves value to cell without deformation and converting Used to be called ...

2018Jun26
Card image
WeekNum

Generates the calendar week number for a certain date, counting the first week ...

2018Jun26
Card image
EnvVar_All

Read all Environment variables using EnvDir_All Or quickly get user folder, or ...

2018Jun17
Card image
MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

2018Jun17
Card image
MatchIf (aka VMatchIf)

The best Match I created, return 0 if not found, kind of CountIF+Match ...

2018Jun16
Card image
HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject

2018Jun15
Card image
ANStrRead + ANStrSave + ANStrSearch

Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...

2018Jun14
Card image
FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

2018Jun11
12...101112