Search results 96

Sorted from new to old.

PivotTable_ShowHideItems

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

Jan23

PivotTable_ShowHideBlankItems

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

Jan22

SQL Cross Apply String_Split with XML Path

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

Jan20

ANmaPivotTable_Clear

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

2023Dec22

ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

2023Dec17

SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12

Latest records date and count

Find how many items in table, with column DateAdded is the latest DateAdded in ...

2023Nov2

ContainerHTMLTag_Index

Returns location of the tag that enclosing the location provided inside HTML ...

2023Oct22

ContainerHTMLTag

Returns HTML tag of the container of certain location inside HTML block. ...

2023Oct21

ANmaFilter3

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

2023Oct13

USB format in Android

What is the best format to use a USB storage for using in Android phones and ...

2023Sep28

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

2023Aug28

ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

2023Aug13

CreditCardType

Returns credit card type and whether it is valid or not. Found it in my old ...

2023Jul28

Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

2023Jul19

Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11

1 2 ...5 6