Search results 62

Sorted from new to old.

Formulas_FromFile_ToRow

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

2025Oct11

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

ANStrSort2

Sorting items inside ANStr, this one in ASP Classic (VBScript) Like the VBA ...

2025May25

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

2024Apr18

CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

2024Jan1

Webfont generater

Online tool. Generate web font to be used in websites. When trying to fix ...

2023Nov27

Column1Range

Return range of cells in column having data where, ignoring header cell and ...

2023Oct7

CopyDynamicRangeValue

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

2023Aug10

Dynamic iframe height

Adjust iframe height to its content after loading page Needed this trick in ...

2023Apr29

GetGroupMembers

List All the Members of a Group Needs GroupNames text file having list of ...

2022Feb1

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

2021Dec30

RandomUniqueID_Sheet

Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...

2021May29

Window and screen sizes in jQuery

Get the size of the screen, current web page and browser window using jQuery ...

2021Mar18

Input text - pre-Placeholder

Remove text when textbox is selected, then put it back if it left empty This ...

2020Oct10

1 2 3 4