Search results 176

Sorted from new to old.

VBA/Excel Registry hacks

Set of hacks to modify Excel/VBA settings using Windows registry (Regedit) ...

Mar12

FilesIn2 - sorted files

List of files, sorted by name, size or modified date ascending or descending. ...

2024Nov25

ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

2024Nov10

ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

2024Nov8

FixURL

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

2024Sep16

ExtractNumeric_FromCell

Returns the number from an HTML cell after cleaning and finding sign. We faced ...

2024Aug6

Daily folder

Create daily folder in specific location automatically. I used to have .bat ...

2024Jul28

QuarterNumber_FromDate

Returns the number of quarter from a date

2024Jul26

DateDiff_Networkdays

Calculates no of workdays between two dates. Option to use international ...

2024Jul25

Center Userform

Looks like forcing a Userform to be in center of an application is not as easy ...

2024Jul23

ANmaSearch_AposFriends

Searches for string inside string with apostrophe possibility (or as I call ...

2024Jul11

CalculateQuarterText

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

2024Jun10

Q_NoOfdays

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

2024Jun9

ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

2024Apr23

Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

2024Mar14

HTML_InsideTag_ByIndex

Checks if LocIndex is found between open and close of HTMLTag or between close ...

2024Feb28

1 2 ...10 11