Search results 477

  2. Search results
  3. rom
Sorted from new to old.
Card image
FS_CopyFile

Copies a file

2018Jun24
Card image
LogSheet_Add + LogSheet_Clear

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

2018Jun24
Card image
RemoveChars

Removes all chars found in Chars_to_remove from String1

2018Jun22
Card image
GetTimeZone

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

2018Jun22
Card image
GetUTC

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

2018Jun22
Card image
RunFromTemp

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

2018Jun17
Card image
CellCommentRead + Save

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

2018Jun17
Card image
CellRead

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

2018Jun16
Card image
Match4

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

2018Jun16
Card image
Match3

Matching three values at the same time in three columns Just like Match the ...

2018Jun16
Card image
Match2

Matching by two values at the same time in two columns Just like Match the ...

2018Jun16
Card image
HMatchIf

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

2018Jun16
Card image
MatchIf (aka VMatchIf)

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

2018Jun16
Card image
Reversefile

Reversing a file This tip demonstrates how to reverse a whole file. This ...

2018Jun16
Card image
GetColumnName, ColumnName_XOffset

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...

2018Jun15
Card image
ANStrRead + ANStrSave + ANStrSearch

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

2018Jun14
12...282930