Codes recently updated

New versions for codes, updated recently by our developers. 24 most recent codes.
{{$CodeName$}
ANmAddressRefStyle v2

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

Sep29

{{$CodeName$}
ANmAddressSame v2

Checks if passed addresses are referring to same cell regardless of ...

Sep29

{{$CodeName$}
FixURL v2

Return safe URL after converting critical chars to whatever passed in SafeChar

Sep16

{{$CodeName$}
Frequency v2

Checks how many items in an ANStr ANStr is list of items separated by a ...

Sep6

{{$CodeName$}
Choose2 v2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

Sep3

{{$CodeName$}
Q_NoOfdays v2

Calculates number of days for certain quarter, starting from given quarter with ...

Aug24

{{$CodeName$}
MyDayName v4

Returns the day name in several formats It uses either full date or only ...

Aug21

{{$CodeName$}
RemoveHTML v2

Removes HTML code Basically all tags expected and listed below There is a ...

Aug19

{{$CodeName$}
ExportSheets_to_1PDF v2

Export multiple sheets as pages in 1 pdf doc. Passing list of sheets as ...

Aug15

{{$CodeName$}
VBA vs ASP Classic v9

Differences between coding in VB in Classic ASP (aka VBScript) and VBA (aka ...

Aug13

{{$CodeName$}
WorkbookOpen_ANmar v3

Opens Workbook without running AutoMacros and without letting the user know ...

Aug13

{{$CodeName$}
DosCommand_Read v2

Get output of DOS Command in string, by reading output into temp text file, ...

Aug11

{{$CodeName$}
DirsCombo_Read v2

Read directories in a specified folder into a combobox Needs FrmBr having Cbo1

Aug11

{{$CodeName$}
HTMLPadding_or_Margin v8

Finds the padding or margin from a style statement for an HTML tag. Passing ...

Aug10

{{$CodeName$}
CutLeftNumber v3

Cuts the left part of string as long as it is number Keeps getting characters ...

Aug10

{{$CodeName$}
HTML2Str v2

Special version to convert HTML to string. Uses RemoveHTML, then after that it ...

Aug4

{{$CodeName$}
CutString9 v2

Cuts from CutFrom starting from any of items found from ...

Aug3

{{$CodeName$}
CutString8 v2

Cuts a string from certain character to certain character with option of either ...

Aug3

{{$CodeName$}
CutString11 v2

Cuts long string from certain character to certain character with option to ...

Aug3

{{$CodeName$}
CutString97 v2

Cuts part from large string from certain character to certain character with ...

Aug3

{{$CodeName$}
CutString v5

Cuts a string from certain char till certain char, can be used to cut left, ...

Aug3

{{$CodeName$}
ANmaRemoveNestedTags v2

Remove tags that are identical and nested inside each other in an HTML document, ...

Aug2

{{$CodeName$}
VBA Progressbar (Frm73) v2

Progress bar Frm73 or just simple message Zip file contains .frm and .frx ...

Aug1

{{$CodeName$}
Unblock blocked macros. v2

Unblock macros in file copied or downloaded from another machine. Excel keeps ...

Jul28