Search results 26

Sorted from new to old.

Range().top below hidden rows

Hidden rows change the .top of below ranges. It turns out that the range().top ...

Jan13

VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

2024Jan26

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

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13

ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

2022Nov11

ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

2021Nov26

2 VB.net pdf books

Free from apress website https://www.apress.com More books

2021Mar2

SumOf_3Filters

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

2021Jan29

ProtectString + UnProtectString

Protects or unprotects a string giving a password Using XorD and similar to ...

2020Jan10

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3

img-2 lazy loading

A library to delay load images as needed From

2019Jul12

Sieve

jQuery plugin to search filter content, customize, easy to apply From

2019Jul10

jQuery filtering

jQuery filtering, demo From

2019Jul9

1 2