Search results 43

Sorted from new to old.

VBHTMLInstr

Searches for string in readable text from HTMLBlock. So it will not find what ...

2023Dec3

CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

2023Aug10

NumberEnding

Add st, nd, rd or th to end of number, can be used for dates also

2023May3

DB Functions (By AI)

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

2023Apr23

ArrSort_4Arr

Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...

2023Apr14

ImportCSVs - 1st AI Code

Imports multiple CSVs found in a folder into worksheets of active workbook ...

2023Mar20

Listbox 1st item [Any]

Allow user to select [Any] as first item in list that will deselect all other ...

2022Nov13

ArrSort_3Arr

Sort 3 arrays, ascending or descending based on 1st array. Needed for specific ...

2022Jul24

ANmaSQL_InsertStatement

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

2022Jul3

SumOf_3Filters

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

2021Jan29

Quarter_to_Words

Convert Quarter code to text per special project requirements. A special ...

2020Dec17

UI_2ValidationsUpdate

Apply validation on two cells, when a 3rd cell is changed When modifying a ...

2020May27

ShrinkText

Shrinks a text into smaller text controlling where is the majority will be ...

2019Oct20

FormatMyDate

Formats a date, equivalent to VB6 function 'Format' Also with it, you will ...

2019Jan4

ArrSort_2Arr

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

2018Oct1

PCase

Converts a string into proper case PCase or ProperCase since Classic ASP does ...

2018Sep7

1 2 3