Search results 112

Sorted from new to old.

Variable_PerLocation_FromFullLine

Extract set from ANstring, like 2nd set of variable list using specific ...

Oct16

ShapeCreate_SomeVariables

Create a shape in certain sheet with options Some other options are hard-coded, ...

Sep30

BoldCodeColor

Bold the first letter and color it based on Bootstrap color theme, info, ...

May26

MathInsideText

Return string after applying math to each number found inside the string. ...

May8

ANmaRename2Files

Quick batch file to rename two files. One of my big sources of images for my ...

Mar16

Match6_Until

Searches for six values in six columns and return the row number if all found, ...

2024Nov28

Match4_Until

Search 4 columns with a stop. Tell the function to stop searching after certain ...

2024Nov22

VBInstr_Any

Returns the index where any of the words from AnStrSearchFor found in SearchIn ...

2024Nov17

Walking Columns (Scrollable Columns-Chart)

Allow users to scroll through columns in column-chart. Used chart.js, this is ...

2024Sep30

FixURL

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

2024Sep16

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

2024Sep10

Get boot time

Get the last time Windows 10 was started. Needed this quickly for research.

2024Sep6

ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript Edit ...

2024Aug11

Unblock blocked macros.

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

2024Jul27

ANmaSearch_AmpFriends

Searches for string inside string with multiple possibilities if the char & ...

2024Jul7

NumberNumberNumber

Finds 3 numbers in a string by ignoring characters between them. ' example ...

2024Mar2

1 2 ...6 7