Search results 60

Sorted from new to old.

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22

ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

2022Feb4

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27

CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

2021Oct5

Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

2021Jun23

Execute exe embedded in Excel

Execute exe file that embed inside Excel sheet This is for experimental, not ...

2021Apr16

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29

EnvironList

List of all variables of Environ It will populate them in sheet range starting ...

2021Jan12

Generate_PowerPoint

Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...

2020Dec22

ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

2020Nov11

Long filename

How to delete or rename file with long filename, say more than 200 chars. ...

2020Oct11

CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

2020May13

DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

2020Apr3

NameNum

Finding the number of a name, used in a numerology program. Finds the number ...

2020Mar21

Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

2020Feb22

1 2 3 4