Search results 38

Sorted from new to old.

Excel 2408 bug

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

Sep10

ANmaSearch_OrFriends

Search for one of items in SearchFor_ListOfFriends inside SearchIn and return ...

Jul30

Daily folder

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

Jul28

CalculateQuarterText

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

Jun10

Q_NoOfdays

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

Jun9

Random Number in SQL

Generate Random number inside SQL using timestamp (GetDate function) One of ...

Jan30

ReadFileBytes

Reads bytes from file using FSO, Number of bytes can be decided as well as ...

Jan15

Webfont generater

Online tool. Generate web font to be used in websites. When trying to fix ...

2023Nov27

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

2023Aug28

O365 Blocked Macros

Recent Microsoft 365 Excel blocked macros from running when they are in ...

2023Jul10

Excel user name

Get application user name or change it Originally from

2023Jun14

Detailed errors - Web.config

Show detailed error using Web.config Was always struggling with the exact ...

2023May25

Windows Common Controls 6.0

This is the needed library to have Windows Common Controls installed to be used ...

2023Feb19

FontAwesome icons in Office apps

Best way to use FontAwesome set of icons in apps, mainly my Excel tools and ...

2023Jan31

ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

1 2 3