Search results 74

Sorted from new to old.

ANStrVLookupAll

Retuns list of all matchings after doing vlookups to return item from 2-dim ...

2025Jun14

Header font name and size in VBA

Looks like it is not easy to change font name, size and style for a header or ...

2025Jun1

CSS Generators

One of my newest friends in css styling, tons of options. Love the simple ...

2025May22

SSL/TLS certificate add/update

Always found myself struggling when applying security to websites for the past ...

2024Nov7

ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

2024Oct31

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

Center Userform

Looks like forcing a Userform to be in center of an application is not as easy ...

2024Jul23

Install/Uninstall SQLNativeClient DB driver

Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...

2024Feb8

Win10 ThisPC Virtual locations

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

2024Feb5

SQL instr

Searching for a string inside a string in SQL. You may say it is the instr in ...

2024Feb3

ConcatenateStrings_AmongString

Collect strings matching search from a longer string. I used it to concatenate ...

2024Jan17

Remove Managed by Your Organization from Edge

AI helped me here to remove the message on my browser of (Managed by your ...

2024Jan10

HTMLPaddingMargin_v2

Finds the padding or margin from a style statement for an HTML tag. Passing ...

2024Jan5

1 2 3 4 5