Search results 186

Sorted from new to old.

Latest records date and count

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

2023Nov2

AddressReferenceStyle

Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...

2023Nov1

HMatchIf_Multi

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

2023Oct30

LEGO UI Controls

Nice CSS-LEGO-UI Controls Originally from

2023Oct16

ANmaFilter3

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

2023Oct13

Column1Range

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

2023Oct7

End ( xlDown )

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

2023Aug28

SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

2023Aug17

CopyDynamicRangeValue

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

2023Aug10

Bootstrap 5 color toggle

Working toggle button to switch between light and dark color modes in Bootstrap ...

2023Aug6

Zoomed iframe

Show iframe zoomed or in scale Thanks to

2023Aug4

Autofit height iframe

iframe with animated gif to show while loading content, when iframe is fully ...

2023May25

Range22DimArray

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

2023May11

ForegroundColor

Returns white (RGB 255,255,255) or Black (RGB 0,0,0) based on background color ...

2023May5

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

1 2 ...4 ...11 12