Search results 174

Sorted from new to old.

Fill down

Fill down series in Excel. NotReadyYet! This is a work-in-progress function! ...

2022Jan5

GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

2021Nov26

fNMRPrgs, Full-form progress bar (frm77)

Show progress bar inside userform, with option to control lots of things. This ...

2021Oct5

Logging use of executable in Windows

Log the use of .exe, .lnk, .pif, .bat, and .com files on your computer. All it ...

2021Jun13

Open Window

Open another window with java script (_blank) Setting up width, height, ...

2021Mar22

SumOf_3Filters

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

2021Jan29

ToolPath

Returns the path of ThisWorkbook considering OneDrive Personal or Business ...

2021Jan12

Wrong file permissions

Fix to unable to delete file from FTP server after uploading using PHP function ...

2020Dec21

BrowseImage

Asks user to select an image and returns full path and name of selected image ...

2020Dec19

Resize_Me2 + Resize_Me3

Resizes Excel window to certain small size and location (hard-coded) and hide ...

2020Dec11

ExitTool and DoNothing

My way of Exiting tool in case or error, also another sub that basically does ...

2020Oct31

CellSave and CellRead

Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...

2020Oct31

CountDuplicates

Counts how many duplicates found in a range of Excel cells. Basically how many ...

2020Oct31

Part of cells in Excel

How to modify part of text inside an Excel cell using VBA. Something in my ...

2020Oct13

TrimEnters

SQL Function to remove repeated Enters from a string in SQL Chr(13) + Chr(10)

2020Sep19

Numeric Input Spinner

A nice Bootstrap 4 numeric spinner used on Input box Originally from

2020Sep17

1 2 ...5 ...10 11