Search results 500

Sorted from new to old.

RGB2HTML + HTML2RGB

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

2018Jul9

Shapes-Macros

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

2018Jul9

LoadPicture_Safe

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

2018Jul7

FixENTERS_File

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

2018Jul7

SwapDate

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

2018Jul5

FormulasFlatten

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

2018Jun30

WordsOf + Words_Len

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

2018Jun28

Distance_Calc_fromString

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

2018Jun27

SettingRead_JR

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

2018Jun26

CellRead (SimpleLookup)

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

2018Jun25

FS_CopyFile

Copies a file

2018Jun24

LogSheet_Add + LogSheet_Clear

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

2018Jun24

RemoveChars

Removes all chars found in Chars_to_remove from String1

2018Jun22

RunFromTemp

Check if an Excel file is running from 'Temp' location or regular folder This ...

2018Jun17

CellCommentRead + Save

Reads/Saves a comment into a cell CellCommentRead to Reads comment from a ...

2018Jun17

CellRead

Reads a value giving column, row, sheet and workbook name Accepts up to 2 ...

2018Jun16

1 2 ...29 ...31 32