Search results 168

Sorted from new to old.

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23

ANmaInt

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...

2023May2

DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

2023Apr23

AskForFolder

Asks user to assign a folder, been looking for something like this for awhile ...

2023Mar23

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

UnixDateTimeNumber

Calculates Unix date/time number of a given date/time. Needed it to pass ...

2023Jan6

JsBarcode

Generate barcode in js Tested and works better than others

2022Dec26

ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

2022Nov11

DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

2022Aug17

Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

2022Jul19

Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6

DBTable2CSV

Exports table into CSV from ASP Classic function.

2022May31

CSVs2Sheets

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

2021Oct5

DegreesToXY

Calculates X, Y of position on a Circle or ellipse. Pass the center X, Y of ...

2021Jun13

Morse code functions

Convert text or single character to and from Morse code. TexttoMorse, ...

2021Jun13

1 2 3 ...10 11