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 ...

Sep10

Unblock blocked macros.

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

Jul27

IfString_StartsWith_AndOr_EndsWith

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

Jul18

CountRowCells

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

Jun22

Q_NoOfdays

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

Jun9

ANmAdd_ThenSort_2Columns

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

Jun1

CopyFiles Excel-Macro

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

Mar12

HTML_InsideTag_ByIndex

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

Feb28

CutString_ReverseFrom

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

Feb27

CutString9

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

Jan7

Protect txt file into word doc with password

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

Jan4

CutString7

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

Jan1

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