Search results 499

Sorted from new to old.

Formulas_FromFile_ToRow

Imports formulas from file into list of cells defined in file itself into ...

Oct11

Formulas_FromRow_toFile

Exports all formulas in a row of sheet into text file.

Oct10

Create Tree from 3 columns (Sheet2Tree)

Converts 3 columns in sheet into 3-generation tree using TreeView from Mscomctl. ...

Aug7

QTexts_Min

Returns minimum quarter of 2 strings representing quarters, like 1Q2024, 3Q2015, ...

Jul27

CutString_JsonKeyValue

Reads value from json string for certain key. Using RegEx Regular Expression. ...

Jul27

Calculation_StaleValues

Show Stale function formats or hide Excel recently started to show cells with ...

Jun30

Outlook data files

Custom default location for Outlook data files. Tell Outlook to always store ...

Jun18

ANStrVLookupAll

Retuns list of all matchings after doing vlookups to return item from 2-dim ...

Jun14

ANStrVLookup

behaves as vlookup to return item from 2-dim ANStr Can choose which column, ...

Jun14

ANmAraDate

Format full date in Arabic language using several known Arabic month syntax. ...

Jun12

Header font name and size in VBA

Looks like it is not easy to change font name, size and style for a header or ...

Jun1

DBTableCol_Array

Reads 1 column from SQL DB table and return as 1-dimension array oConn object ...

May30

Add bulk rows to DB Table

Inserts multiple rows into DB table as whole Unlike

May27

BoldCodeColor

Bold the first letter and color it based on Bootstrap color theme, info, ...

May26

ANmaSearch_AnyWord_FromANStr

Checks if string has any word from ANStr inside it Unlike

May26

MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

May10

1 2 ...31 32