Search results 181

Sorted from new to old.

Font-Based progress bar

Show progress bar using fonts only. Neat trick to use inside HTML or word ...

2024Sep29

Unblock blocked macros.

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

2024Jul27

ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

2024Jul24

Center Userform

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

2024Jul23

Q_NoOfdays

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

2024Jun9

MatchIf6Up

Searches for 6 values in 6 columns and return the row number found in. ...

2024May31

MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

2024May31

MatchIf5Up

Searches for five cells in five columns and return the row number if all found ...

2024May27

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

2024Apr29

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

2024Apr18

ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

2024Apr15

SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

2024Apr15

MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

2024Apr8

Just learnt that now

Looks like we cannot have filename (having no extension) and folder in same ...

2024Mar5

OrderedList in Arabic Alphabet

Using Arabic in ordered list in HTML, as Abjad or Alphabet. Was playing with ...

2024Feb25

VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

2024Feb25

1 2 ...11 12