Search results 231

Sorted from new to old.

CountRowCells

Counts how many cells with data in a row, starting from certain column until ...

2024Jun22

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1

ANmaCellFormat

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

2024Apr18

SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

2024Apr15

ContainerHTMLTag_ReturnBlock

Returns the full string starting from open tag of container where LocationIndex ...

2024Apr3

Just learnt that now

Looks like we cannot have filename (having no extension) and folder in same ...

2024Mar5

EdgarCIK

Search for company long name in Edgar and returns its CIK Using SEC.gov site ...

2024Feb25

Send workbook as email attachment

Retro way to send a workbook you are in as an email. Found it in one of my old ...

2024Feb14

Win10 ThisPC Virtual locations

I hate it when Windows forcing us to have additional items in "This PC" So, I ...

2024Feb5

PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

2024Jan23

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

2024Jan22

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

2024Jan20

ImgDimensions

Reads image dimensions, width, height, depth and image type. Details returned ...

2024Jan16

ReadFileBytes

Reads bytes from file using FSO, Number of bytes can be decided as well as ...

2024Jan15

MultiRead_JSON

Reads array of arrays from the parent and return back ANString of 3 columns

2024Jan13

SettingRead_Ajax + SettingRead_Ajax_IntoObject

Two functions to return an output of file into object on page or back to caller ...

2024Jan12

1 2 ...14 15