Search results 76

Sorted from new to old.

AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22

LastRow_Remove

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

2022Aug16

Export2CSV

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

2022May16

UISetup + UIRestore

Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...

2022Jan28

InStr and InStrRev

How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...

2021Dec6

EnvironList

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

2021Jan12

File_SettingRead

Reads setting from config file Config file can be passed as argument ...

2020Sep23

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

2020May6

ShortenDir

Shorten a long Dir by adding ... in the middle to make it fit in small boxes ...

2020Feb19

Reset ID Column

How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...

2020Feb9

ANSQLWherein

Creates list of items to be used in ' Where item in (List)' list Mainly adds ...

2020Jan6

ImagesIn_User

Gets images in a folder where filenames start with "User" Similar to function ...

2019Dec31

Bootstrap-DatePicker

bootstrap-datepicker This is a fork of Stefan Petre's [original code](

2019Aug31

Excel 2010 hyperlink issue fix

An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...

2019Jun16

Send To folder

Where can I find the SendTo folder? I always wanted to modify that list and ...

2019May15

Windows XP as website

Having a website that looks like Windows XP is great out-of-the-box idea Here ...

2019Jan17

1 2 3 4 5