Search results 94

Card image cap
Latest records date and count

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

Card image cap
HMatchIf_Multi

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

Card image cap
ANmaFilter3

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

Card image cap
Column1Range

Return a range of cells in column where ... Return Range Ignore header ...

Card image cap
End ( xlDown )

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

Card image cap
CopyDynamicRangeValue

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

Card image cap
Range22DimArray

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

Card image cap
DB Functions (By AI)

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

Card image cap
Convert_Dash_to_Zero

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

Card image cap
Range2Block

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

Card image cap
ANmaVLookup

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

Card image cap
ANStr2Range

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