MyDev

Search results 27

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

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

2020Dec22

Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...

2020Sep21

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3

Sort 2 1-dimension arrays Actually sort 1st array (Array1) based on values ...

2018Oct1

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...

2018Aug9

Convert text blocks (by converting line separators from any separator to any). ...

2018Jul11