Search results 503

Sorted from new to old.

WeekNum

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

2018Jun26

SettingRead_JR

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

2018Jun26

TimeRound

Rounds the number of minutes to the nearest quarter of half like 4:32 to 4:30 ...

2018Jun25

LogSheet_Add + LogSheet_Clear

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

2018Jun24

RowsCount

Get total number of rows for a certain worksheet in certain workbook workbook ...

2018Jun22

RemoveChars

Removes all chars found in Chars_to_remove from String1

2018Jun22

ASCII_Read + ASCII_Save

Reads and saves text file giving its full name Used a lot in my websites, very ...

2018Jun21

Hex2Dec

Converts hexadecimal strings into decimals

2018Jun20

FGColor_Calc

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

2018Jun20

confirmDelete

Asks user before running a link (mostly before deleting) Small important part ...

2018Jun19

BinaryFile_Read + BinaryFile_Save

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

2018Jun18

ScreenRes

Reads screen resolution, using IE this time, this one will get the active ...

2018Jun17

ScreenResolution_wxhxtxl

Detects active desktop screen resolution and location of taskbar (with some ...

2018Jun17

MatchIf_ThenDelete

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

2018Jun17

CellRead

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

2018Jun16

Match4

Matching 4 values at the same time in 4 columns Just like Match the function, ...

2018Jun16

1 2 ...28 ...31 32