Search results 60

Sorted from new to old.

Excel 2408 bug

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

2024Sep10

Unblock blocked macros.

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

2024Jul27

IfString_StartsWith_AndOr_EndsWith

Checks if String starts with certain char and ends with certain char Or one of ...

2024Jul18

CountRowCells

Counts how many cells with data in a row, starting from certain column until ...

2024Jun22

Q_NoOfdays

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

2024Jun9

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

2024Jun1

CopyFiles Excel-Macro

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

2024Mar12

HTML_InsideTag_ByIndex

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

2024Feb28

CutString_ReverseFrom

Returns full string starting from the point of LocIndex minus back where we ...

2024Feb27

CutString9

Cuts from CutFrom starting from any of items found from ...

2024Jan7

Protect txt file into word doc with password

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

2024Jan4

CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

2024Jan1

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

SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12

Column1Range

Return a range of cells in column where ... Return Range Ignore header ...

2023Oct7

1 2 3 4