Search results 60

Sorted from new to old.

PrevWeekday

Returns date of the previous weekday (Friday, Saturday, Sunday, etc) from ...

Feb1

Excel 2408 bug

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

2024Sep10

HTMLRow_Cell

Returns column with ColumnID ... the full area between < td ...> and < /td> ...

2024Aug4

DateDiff_Networkdays

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

2024Jul25

JSON_To_Table

An attempt to read json into table. This one is a work in progress, tested and ...

2024Jun6

MatchIf5Up

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

2024May27

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1

ListBox bug with TabIndex

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

2024Apr15

CopyFiles Excel-Macro

Simple macro to make sure we have a copy of all files in a folder found in ...

2024Mar12

OneDrive Reset

Reset OneDrive because I am a heavy OneDrive user. Most recent instructions, ...

2024Mar5

Protect txt file into word doc with password

Saves txt file as word doc with password. Passing txtfile having full path and ...

2024Jan4

FontAwesome Custom icons issue

I faced an issue the past few weeks when trying to add my own icon to ...

2023Dec29

Macro keyboard shortcuts

Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...

2023Dec13

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28

Total14Round

Round time to Hours:Minutes format regardless of number of days Like in 80:40. ...

2023Aug8

Modal form open Workbook

Do not open workbook from userform after .show

2023Aug3

1 2 3 4