Search results 14

Sorted from new to old.
Card image
SSL/TLS certificate add/update

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

Card image
ANmAddress_Value

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

Card image
HTMLTable_NoOfColumns

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

Card image
CleanArray_2Dim

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

Card image
ANmAddressSame

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

Card image
ANmAddressRefStyle

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

Card image
ReplaceStrings

Replace strings found in list of strings from inside a string, does that make ...

Card image
AddressReferenceStyle

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

Card image
List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

Card image
Range22DimArray

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

Card image
HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

Card image
Fill down

Fill down series in Excel. NotReadyYet! This is a work-in-progress function! ...

Card image
Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

Card image
CreateZipFile_7Zip

Compress a single file into zip archive using 7Za.exe 7za.exe (found in ...