Search results 81

Sorted from new to old.

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

ANmaFill

Fill down series in Excel range starting from certain number with certain ...

2022Jan5

InStr and InStrRev

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

2021Dec6

Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

2021Oct13

CutString8

Cuts a string from certain character to certain character with option of either ...

2021May29

EnvironList

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

2021Jan12

BrowseImage

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

2020Dec19

File_SettingRead

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

2020Sep23

ShortenDir

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

2020Feb19

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

ANBSCaptchaBox (Part 4)

Attempt to create Captcha inputbox as simple as possible using third party ...

2019Dec7

Excel 2010 hyperlink issue fix

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

2019Jun16

HeadingZeros Remove and Add

Adds or remove zeros at start of string Used to clear heading zeros from ...

2019May31

1 2 ...4 5 6