Search results 46

Sorted from new to old.

Match5_5thNot0 and Match6_6thNot0

Searches for 4 cells in 4 columns then checks for 5th column to not equal zero ...

2024Nov13

Showing 4k (and more) images in BS5 modal

Allow users to browse and scroll through tons of images to select one (tried on ...

2024Nov7

ANmAddressSame

Checks if passed addresses are referring to same cell regardless of ...

2024Sep24

ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

2024Sep23

SQL Cross Apply String_Split with XML Path

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

2024Jan20

SettingRead_JSON

Reads certain value for a certain setting from FullJSONString text block. See ...

2024Jan8

Feature-rich Lightbox Gallery BS5

A JavaScript lightbox gallery plugin for showcasing images, videos, Instagram ...

2023May6

WordPress - Excel functions (AI)

3 functions to download posts, adds new post and to upload and set featured ...

2023Apr22

Arabic in MySQL

Here is how to read Arabic text from MySQL db from Classic ASP I tried a lot ...

2023Apr12

ScanFolder

Scans folder and its all subfolders (2 levels only) for files then put file ...

2023Apr7

EmailSend_Outlook

Send email using Outlook object with attachments With AI-generated post image. ...

2023Apr5

Convert_Dash_to_Zero

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

2023Mar14

DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

2022Aug17

Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6

SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

2022Jul6

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26

1 2 3