Search results 56

Sorted from new to old.

ShapeCreate_SomeVariables

Create a shape in certain sheet with options Some other options are hard-coded, ...

2025Sep30

ANStrVLookupAll

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

2025Jun14

Header font name and size in VBA

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

2025Jun1

FilesIn_4Array

Returns list of file names along with path, date modified and size in array of ...

2025May25

1st cell of sheet range

Returns the address of first cell in data in range, the very first cell of very ...

2025May12

CutString_ANmaRules

Extract certain text from another text based on Rules defined, like extracting ...

2025Feb26

VBInstr_Occurance

Returns location of text inside another with jump ability for any certain ...

2024Dec1

FilesIn2 - sorted files

List of files, sorted by name, size or modified date ascending or descending. ...

2024Nov25

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

2024Nov18

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

2024Aug11

CreateThumbSquare_IrfanView

Creates square thumb for an image, regardless of image aspect ratio It will ...

2024Jan18

ChartLegendCenter

Put chart legend at center of chart horizontally. Changes left and width only. ...

2023Dec21

SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

2023Aug17

Frm3

Browser window in a userform Just add Frm3 and call Frm3.Frm3_OpenWeb passing ...

2023Jul30

Excel user name

Get application user name or change it Originally from

2023Jun14

Windows7 css

A CSS to format website as Windows 7. From

2023May30

1 2 3 4