Search results 19

Sorted from new to old.

HTMLTable_NoOfColumns

Gets no of columns in an HTML table. It actually gets the maximum number of ...

2024Oct26

CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. Similar to

2024Oct24

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

Win10 ThisPC Virtual locations

I hate it when Windows forcing us to have additional items in "This PC" So, I ...

2024Feb5

Win98 css theme

Win98 CSS in html Similar to Win95 CSS

2023May29

Autofit height iframe

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

2023May25

MapPath_SafeComma

MapPath version expecting comma in filename or folder. Just because we might ...

2023May19

ArrSort_4Arr

Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...

2023Apr14

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

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

Animated form exit

Exit form with shrinking Shrinks the form, Pushes the form to the bottom of ...

2020Feb16

Is64Bit

Determine if system is 64 bit or not. Related to

2020Feb7

HeadingZeros Remove and Add

Adds or remove zeros at start of string Used to clear heading zeros from ...

2019May31

DirTree.xlsb

Excel macro to show all files found in directory (including sub-directories) as ...

2019May20

1 2