Search results 131

Sorted from new to old.

BS5 Cards

2 Cards design in Bootstrap 5 from

2023Nov23

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

HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

2023Oct30

ANmaFilter3

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

2023Oct13

Column1Range

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

2023Oct7

End ( xlDown )

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

2023Aug28

CopyDynamicRangeValue

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

2023Aug10

Range22DimArray

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

2023May11

DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

2023Apr23

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

ANStr2Range

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

2022Nov11

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22

1 2 ...4 ...8 9