Search results 472

Sorted from new to old.
Card image
RGB2HTML + HTML2RGB

Converts RGB color to / from HTML format As bonus, functions RGB_ExtractColor ...

Card image
Shapes-Macros

Read shapes in all worksheets in certain workbook and return list of macros ...

Card image
LoadPicture_Safe

Loads an image into VBA image control without knowing its extension If file ...

Card image
FixENTERS_File

Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...

Card image
SwapDate

Changes date format from US to International or from international to US. ...

Card image
Sort1Col

Sorts a column in Excel, easily, with options

Card image
FormulasFlatten

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

Card image
WordsOf + Words_Len

WordsOf to create list of words from a block after converting every special ...

Card image
Distance_Calc_fromString

Calculate distance between two points (Latitude, Longitude) LatLon1 and ...

Card image
SettingRead_JR

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

Card image
CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

Card image
FS_CopyFile

Copies a file

Card image
LogSheet_Add + LogSheet_Clear

2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...

Card image
RemoveChars

Removes all chars found in Chars_to_remove from String1

Card image
GetTimeZone

Get local timezone Uses w32tm / tz dos command in command prompt Using ...

Card image
GetUTC

Get the time and date in Universal time based on local time Uses w32tm / tz ...