Search results 179

Sorted from new to old.

ANmaReplace_Occurrence

Replaces certain occurrence of a string with another inside a string. Like ...

2024Jul13

CountRowCells

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

2024Jun22

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1

CopyFiles Excel-Macro

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

2024Mar12

Steps Recorder Win10 app

Win10 application already found in Windows. to generate list of steps with ...

2024Feb16

Send workbook as email attachment

Retro way to send a workbook you are in as an email. Found it in one of my old ...

2024Feb14

gsplit usage

How to use gsplit to split large files into smaller parts to allow to read it. ...

2024Feb7

Random Number in SQL

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

2024Jan30

Gototop + Circular scroll progress

JS icon to show progress of scroll in webpage having button to go back to top. ...

2024Jan28

PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

2024Jan23

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

2024Jan22

Frm58

Build needed lines to create string variable having block of HTML. Provide the ...

2023Dec25

Frequency1

Finds how many a string found inside larger string. Similar to Frequency but ...

2023Dec16

PrCal_Add_Sort

Adds to daily log, two cells, one with date, next with activity that will be ...

2023Dec2

Latest records date and count

Find how many items in table, with column DateAdded is the latest DateAdded in ...

2023Nov2

Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

2023Sep1

1 2 ...11 12